Forum Discussion
NickProp28
5 years agoPost Partisan
Change DAX measure into Power Query Editor Custom Column
Dear Comunnity, I have a DAX measure as below, and would like to change it into power query custom column. I wonder isit able to do that, because if I create a measure with DAX, I unable to use t...
lbendlin
5 years agoSuper User
DAX measures cannot be rewritten in Power Query because they are computed dynamically based on user filter selections.
Your item above seems to be a calculated column (not a measure) so it can be converted to Power Query. However your sample PBIX (thank you for posting it) points to a local file data source
'C:\Users\nikchoo\Desktop\Testingconsignornee.xlsx'
that we of course don't have access to. Please post the sample data as well.
- NickProp285 years agoPost Partisan
Dear lbendlin,
Thank you so much for your attention.
My apologies. Here's the pbix and excel file: https://ufile.io/q2pty4w9
Greatly appreciated.
- NickProp285 years agoPost Partisan
Dear lbendlin ,
Good day!
At your convenience would you mind have an update on this please?
Much appreciated.