Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago

Speeding up calculated column time

Hi there,     I am calculating a column using DAx language.  The new column is the rolling sum of 48 half-hourly values. The calculation of column is :   calculated col = sumx(filter(Table1, Tab...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Dunner2020 ,

 

Check if the formula work.

 

calculated col = 
var tmp = filter(Table1,Table1[EpochHH] >= EARLIER(Table1[EpochHH])-47 && Table1[EpochHH] <= EARLIER(Table1[EpochHH]))
return
calculate(sum(Table1[value]),tmp)

 

 

Best Regards,

Jay