Hi there, I am calculating a column using the above-mentioned logic in DAX: Last 24 hr Raw = 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 …

Hi @leo_89 , Had to do some testing to speed this up, so I hope performance is acceptable when scheduled in the Service. If not and you can’t retrieve this value from the source, you’re back to a calculated column… Here’s what I’ve done. Set up. // Sort EpochHH Ascending AND buffer the 30 Mins Raw…

Dax into power query

Power Query

leo_89 April 22, 2021, 12:14am 13

@Melissa,

Result:

Calculating max value using power query