convert measure into a power query

[Anonymous]

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(opportunities[Opp to Opp closed number of days]),ISONORAFTER(opportunities[Opp to Opp closed number of days],MAX(opportunities[Opp open to opp closed]),DESC)))

var totalsales=CALCULATE(SUM(opportunities[ex_numberofusers]),ALLSELECTED(opportunities))

return DIVIDE(sales,totalsales)

[Riantilo]

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,