Run M code on calculated table

[Anonymous]

I have a set of transformations/ M code to run on a table which is a calculated table. To apply these transformations, I am not able to view/see this calculated table in Power query editor. Is there any ways to bring this calculated table to query editor where I can run M code on it ? Kindly suggest.

Thanks,

Sush

[ibarrau · Accepted solution]

Hi. DAX calculations are run directly to the model hosted in the file. Power Query runs against the data sources in order to build the previous model. That's why you can't find in Power Query any component created with DAX.

In my opinion, it will always be better to build tables and columns in earlier steps (DB engine or Power Query). If you want to run Power Query stuff for that table you need to recreate it in your database or in Power Query 🙂

I hope that helps,