Calculated columns to a direct query source

Hi  Anonymous ,

This is not possible.

With calculated columns, you can add new data to a table already in your model. But instead of querying and loading values into your new column from a data source, you create a Data Analysis Expressions (DAX) formula that defines the column's values, after the model content is imported into the memory, the result of the DAX expression is calculated, and the Power Query calculated column is an M expression, which defines the transformation applied to the data source before the table is imported into the data model.

You can take a look at the following articles, apart from the differences in the languages used to create them, there are other differences between them:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-columns

http://radacad.com/m-or-dax-that-is-the-question

https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly