Include calculated columns in Power Query

[o59393]

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!

[mahoneypat · Accepted solution]

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

[Syndicate_Admin]

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.