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:
I have the dataset on the following Dropbox link.
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.
Solved! Go to Solution.
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?