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 community,
YTD Sum =
VAR CurrentMonth = 10
RETURN
TOTALYTD([Sales Measure]
, 'Dates'[Date]
, 'Dates'[Month] <= CurrentMonth)
I want my Sales + Forecast Sum to just add up the red circled values. How can I archieve this?
DAX still is so confusing to me.. I would also appreciate any suggestions of improving my DAX code!
Thanks in advance!
Cheers, Myriam
Solved! Go to Solution.
Okay I think I found out myself. Dunno if thats the "beste" solution, but this is working in my case:
Okay I think I found out myself. Dunno if thats the "beste" solution, but this is working in my case:
@MyriamW I don't mean to offend, but you're doing this all wrong. Most of all, you're hard coding values into variables which means you're going to need to update this every month.
Could you please supply some sample data?
Hi @littlemojopuppy , thanks for your reply.
I should have said that of course in my real report I am not hardcoding any values. I do have variables with MONTH(TODAY()) etc. But as the sample data (I just used some from MS) is not actual data that wouldn't work, and for time reasons I just hardcoded to display my issue.
You can find my sample pbix here: SampleCalculateForecast.pbix
(Hope it is working, I am not able attach the file directly)
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 |
---|---|
105 | |
104 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |