Forum Discussion
From Dax to Power Query
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?
- Anonymous5 years ago
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.
2 Replies
- samdthompsonMemorable Member
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
- AnonymousNot applicable
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.