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!
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
222 | |
68 | |
64 | |
64 | |
57 |
User | Count |
---|---|
251 | |
213 | |
87 | |
85 | |
73 |