Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
Solved! Go to Solution.
Hi,
You may download my solution from here.
Hope this helps.
Hi,
You may download my solution from here.
Hope this helps.
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?
You are welcome. I have updated the file with a new measure which cales yield since inception.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |