Forum Discussion
Cumulative function not showing value when most recent period has no values
I am trying to write a cumulative function for the dark blue bit (Number of Beds) which tracks the light blue bit all the way to the end. Essentially, even in years where no beds were added (I.E. 2022), the graph should still show in that year the same value as the previous year (as you would expect from a cumulative function).
Formula:
Number of Beds (Cumulative) = CALCULATE(SUM('Student Planning Pipeline'[Number of Rooms]),FILTER(ALLSELECTED('Student Planning Pipeline'),'Student Planning Pipeline'[Date]<=MAX('Student Planning Pipeline'[Date])))
Any tips?
2 Replies
- YukiK
Impactful Individual
Does the number of beds have the value of zero or blank? If it's zero, then I'm not sure. If you could attach sample data, it's easier to troubleshoot!
