Forum Discussion
How to use a table with calculated columns (DAX) as a data source in Power Query?
I have a table that I added some calculated columns to as I couldn't work out how to create those columns without DAX. Now I want to reference that table within Power Query again and tranform it. In Excel this is possible if I simply load the table from the Data Model into a spreadsheet and reference that spreadsheet again in Power Query, but I can't work out how to something similar in Power BI.
2 Replies
You can't because DAX is calculated after Power Query steps.
What kind of column do you have in DAX ? maybe it's possible to create it in M
Hi justlogmein ,
Agree with freginier . You may describe your requirement in detail so that we could try use M not DAX to realize your expected output in Power Query directly.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
