Forum Discussion
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...
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.
Dear lbendlin,
Thank you so much for your attention.
My apologies. Here's the pbix and excel file: https://ufile.io/q2pty4w9
Greatly appreciated.
Dear lbendlin ,
Good day!
At your convenience would you mind have an update on this please?
Much appreciated.