Forum Discussion
Include calculated columns in Power Query
Hi all
I created some calculated columns in a table. When I go to Power Query to create a merge between 2 tables, I realize that the calculated columns do not show up on my Power Query's table.
Is there any way to have the calculated columns visible somewhere in the Power Query editor?
Here is the calculated column I created:
Thanks!
No can do. Calculated columns are calculated after the query loads. You'll have to recreate your DAX column in the query editor with nested ifs (or make additional DAX columns, if it can be done that way for you new column(s)).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
2 Replies
No can do. Calculated columns are calculated after the query loads. You'll have to recreate your DAX column in the query editor with nested ifs (or make additional DAX columns, if it can be done that way for you new column(s)).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
I also need that column with DAX formula in Query, but I don't know how to do it, could you create a DAX column in Query?
Thanks a lot.
