Forum Discussion
use column in DAX in Power Query Editor
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 ? :o Because I can't see my created column in Edit Power Query...
Thank you so much for your help !
Tiff
4 Replies
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
Oh... Absolutly no way ? :o
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
