Currently I am trying to do some calculations within Power BI and all of the component parts are working but when i put them together the system tells me that I don't have sufficient RAM.
I have tracked it back to a single part of the calculation but i can't figure a way to do it more efficiently.
CashflowCount = CALCULATE(COUNTROWS('Calendar'),filter(All('Calendar'),'Calendar'[Date] >= MIN(Cashflow[Task.StartDate]) && 'Calendar'[Date] <= MAX(Cashflow[Projects.EndDate])))
This is the calculation which is causing the problem which by itself does resolve after some time.
What i am trying to do is split the interest for a particular caulcation across the period taht the interest will be paid rather than just a total interest in the period it started to be accrued.
Any ideas? I am assuming taht i'm not the only person who has had this problem and i might be missing somehting simple that will solve my problem.
Solved! Go to Solution.
Yp DateDiff was a much better way of doing it.
User | Count |
---|---|
135 | |
84 | |
64 | |
57 | |
55 |
User | Count |
---|---|
212 | |
109 | |
88 | |
82 | |
76 |