Forum Discussion
Need Help with Calculating Drawdown in Power BI: Memory Limit Exceeded Error
Hey I have found the solution, Thank you so much for your time guys,
I had to summarize the new table by limited number of necessary details on day and weekly level and it calculated the drawdown easily.
Hello, aaftab42 ,
generally, you can do cumulative count with date table a fact table just in general formula like this:
cumulative =
CALCULATE(
COUNTROWS('Table'),
'Calendar'[Date] <= MAX('Calendar'[Date])
)This avoids multiple iterations that you have in your formulas.
Another point could be that you have Many To Many relationships that will further slow down the performance.
Feel free to drop sample file of your solution so I can investigate directly on it.
Hi vojtechsima ,
I don't have many to many relationship in my data model. I have tried using date table instead of fact table, but the issue remain the same. I am new to this forum, how to send the the sample file?
aaftab42 hello, just perhaps upload it to Onedrive or Google drive and send the link, you cannot directly attach files unless you're superuser.