Forum Discussion
Solved
Formula not working in Power Query while in the default Power BI pane the new column works
I have a table as per below with HardwareHostname & Last EnterpriseWindows columns for which I could create new colum based on value "1" in the Last EnterpriseWindows colum and also set the value to ...
Hi Dirk_Carpentier ,
Power Query uses the 'M' language and you're trying to feed it DAX.
Looking at your desired calculation, I think you're better off leaving it as a DAX Measure or Calculated Column in the data model and not trying to reproduce it in Power Query (M).
Pete
Hi Dirk_Carpentier ,
Power Query uses the 'M' language and you're trying to feed it DAX.
Looking at your desired calculation, I think you're better off leaving it as a DAX Measure or Calculated Column in the data model and not trying to reproduce it in Power Query (M).
Pete