From Dax to Power Query

[Dunner2020]

Hi there,

I am calculating a column using the above-mentioned logic in DAX:

Last 24 hr Raw SAIDI =
SUMX(
FILTER(‘Fact Table’ , ‘Fact Table’[EpochHH] >= EARLIER( ‘Fact Table’[EpochHH] ) - 47 && ‘Fact Table’[EpochHH] <= EARLIER( ‘Fact Table’[EpochHH] ) ), ‘Fact Table’[30 Mins Raw ])

I want to convert the above DAX formula into power query language. I am not sure is there any alternate for earlier and sumx functions in the query language. Could anyone help me in converting above formula into query language?

[v-stephen-msft · Accepted solution]

Hi @Dunner2020 ,

Add two custom columns

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samdthompson]

Would you want to do create measure in power query? PQ is there to shape and tidy not do analysis. 

in saying that, yes you can with a bunch of steps. You will need some grouping and some indexing. Its worthwhile having a look at this post too, it will sort out your calculation:

Value from previous row – Power Query, M language – ExcelTown – kurzy přesně pro Vás