use column in DAX in Power Query Editor

[Tiff]

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 

[Anonymous · Accepted 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

[Tiff]

Oh... Absolutly no way ? 😮 

I'm stuck in my project so... 

Thank you for your reply ! 😉 

[v-piga-msft]

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

[Anonymous]

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