cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
karimk Regular Visitor
Regular Visitor

Monthly Cumulative Result Not Working

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Monthly Cumulative Result Not Working

Hi,

 

You may download my solution from here.

 

Hope this helps.

3 REPLIES 3
Super User
Super User

Re: Monthly Cumulative Result Not Working

Hi,

 

You may download my solution from here.

 

Hope this helps.

karimk Regular Visitor
Regular Visitor

Re: Monthly Cumulative Result Not Working

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?

Super User
Super User

Re: Monthly Cumulative Result Not Working

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