Forum Discussion
convert measure into a power query
Am looking to convert the below measure into a powerquery code. I have tried recreating but am struggling var sales=CALCULATE(SUM(opportunities[ex_numberofusers]),FILTER(ALLSELECTED(opportunitie...
Can u explain why u want to convert this into Power Query code?
Power Query can only be used to create columns and tables, not a calculated value like a measure does. It is posible to create a table using Power Query that contains a row for eatch month, week or year and the number u want to calculate. This is only usefull if ur using a massive dataset.
Gr,