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.
Hello, Team. I've been struggling with this. I need to calculate the cumulative month total for the current year and for the previous year and present them on the same graph. My problem is that when I present the data, somehow the graph shows data for future dates for the current month. I don't understand why. Today is the 6th of the month, so I have data until the 5th of the month. Therefore, the blue line should stop at the 5th. The numbers from the 1st until the 5th of the month are correct. However, I don't understand where it gets the numbers for the future dates. Thanks!
Solved! Go to Solution.
Hi, @yasbos
Try this:
MaxDate=CALCULATE(max(Sales_Fact[Sale Date]), REMOVEFILTERS('Calendar'[Date]))
Proud to be a Super User!
Please cehck this one Solved: cumulative monthly total - Microsoft Power BI Community
Regards,
Ritesh
Ok, now ... the plot thickens 🙂 I reviewed your referred solution, and I had everything set up properly. I even had tried several variations--all to no avail, and that's what was frustrating. Something strange happened just now, though: I have a measure, Current_Date, in my calendar table. What it does is it gets the max of the dates in my sales fact table, and that is the date that I used as a condition.
Hi, @yasbos
Try this:
MaxDate=CALCULATE(max(Sales_Fact[Sale Date]), REMOVEFILTERS('Calendar'[Date]))
Proud to be a Super User!
If anyone knows why it worked with removefilters, that would save me from the straightjacket. Thanks.
OMG, @ALLUREAN ! That worked. I have NO IDEA what just happened, though. Thanks so much. Thanks to @ribisht17 , too, for responding.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |