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, Table1[EpochHH] > = Ealier(Table1[EpcohHH] )-47 && Table1[EpochHH] <= Ealier(Table1[EpcohHH] ) ), Table1[Value] )

 

In the above calculation, EpochHH is the unique number to identify a half-hour time slot within a day. I have got around 150,000 rows in Table1. When I ran the above command, it takes about 25 mins to calculate the new column. Is there any way to make the calculation quicker?

 

Sample file can be found here

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • 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