Forum Discussion
Solved
how to improve cumulative performance
hi everyone, i have performance issue with cumulative, my idea is to move the logic from powerBI to sql, is it effective ? or any other suggestion ? below my dax script which have performance is...
finally i found the solution
oke, the issue is "slow performance while using cumulative"
root couse -> my chart using "dimdate" instead of "logdate"
solution -> for cumulative dont using relational table, use column that u call in measure
i change from dimDate to logdate and viola from 1 minutes to 15seconds
Anonymous
i have an update sir,
one factor why the performance is not good is because im include year on date hierarchy
without year it takes 4 second, and with year it takes 1 minutes