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 everyone !
I have a column created in DAX and I'd like to use it in Edit Power Query !
Do you know how I can do ? 😮 Because I can't see my created column in Edit Power Query...
Thank you so much for your help !
Tiff
Solved! Go to Solution.
You can't. Power Query Editor only show the original row data. The calcuated column created by DAX can not be shown in Query Editor
You can't. Power Query Editor only show the original row data. The calcuated column created by DAX can not be shown in Query Editor
Oh... Absolutly no way ? 😮
I'm stuck in my project so...
Thank you for your reply ! 😉
Hi @Tiff,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
In addition, it seem that you have concern about custom column and calculated column, you could have a reference of this document.
Best Regards,
Cherry
If its a column that you created after loading the data and clicking on "Close & Apply" then you can't use it in Power Query
The only workaround that I can think of is if you extract your data e.g. in an Excel file and then load it in a new PBIX file as a new table. Alternatively you'll have to recreate your column in Power Query through the use of M Query language
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |