Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |