Speeding up calculated column time

[Dunner2020]

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

[v-jayw-msft]

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

[amitchandak]

@Dunner2020 , This calculation seems fine. Can you please check how much RAM power bi is getting? Is enough memory available to power bi

Check if you can analyze the performance

https://www.youtube.com/watch?v=aYXRx0pZZcs