Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
84 | |
76 | |
64 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |