I have created a measure that calculates the cumulative sum until last month. Here is my measure:
Go to Solution.
Assuming you have dragged Month name from the Calendar Table, this should work
Hope this helps.
View solution in original post
Check out this method:
You should use the CALCULATE and DATESYTD approach.
@grandtotal I am not interested in calculating DateYTD. I wanted to calculate the cumulative sum by the end of last month.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.