Comparing DAX calculated columns with Power Query computed columns
This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns.
When building a data model in Power BI, Analysis Services, or Power Pivot, you might need to extend a table coming from a data source with additional columns, whose content derives from existing data. Several features are available to create such additional columns in the tools mentioned above, and choosing the right feature can sometimes be a challenge. This article describes the main differences between calculated columns based on DAX expressions and computed columns generated by Power Query. As you will see, the choice of a DAX calculated column should be limited to cases where the result is obtained by accessing data in different rows of the same table or in different tables; you should however choose a Power Query computed column when the business logic to implement relies on the values of other columns of the same table.