Monthly Cumulative Result Not Working

[karimk]

Hi everyone.

I´m having a problem getting the correct result with a measure for cumulative monthly results.

My goal: get monthly cumulative values on a line chart for my "rent / square meter" cost. 

Database: One row for each building, for each month. My main columns are "Rent", "Square Meters", "Month" and "Benchmark".

Measures Created So Far:

• Rent Sum
• Square Meters Sum
• Square Meters Cost --> DIVIDE (Rent Sum; Square Meters Sum)

I have the dataset on the following Dropbox link.

https://www.dropbox.com/s/c46paa0lc3xyftv/Dataset%20Example.xlsx?dl=0

It seems that when I try the usual CALCULATE(datecolumn;FILTER(ALL(datecolumn;datecolumn <= MAX (datecolumn))) it will give me the same result as the monthly non cumulative value.

The correct values should be the ones displayed in the "Table" sheet of the database above.

Any help?

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

You may download my solution from here.

Hope this helps.

[karimk]

Thank you very much!

If I have a chart that spans 2 or more years, the DATESYTD formula will only calculate the cumulative value within each year? If yes, what should I do when I want the monthly cumulative value starting on the first and ending on the last years selected?

[Ashish_Mathur]

You are welcome.  I have updated the file with a new measure which cales yield since inception.