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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
74 | |
65 | |
53 | |
53 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |