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.
I am working on to get running sum for cost that doesn't reset on year. I got one formula working but, for some reason it doesn't start with correct number as shown below:
there are no cost before 2017 but running sum line starts from 2014 with some constant cost. please help me figure out what I am doing wrong?
DAX:
Solved! Go to Solution.
yes, AllSELECTED formula works! Also, I made a booboo with date format. (facepalm)
thank you.
on the side note:
If change the formula as shown below, then the chart starts with correct year and amount, however, it doesn't do the running sum.
Just curious, can you try and see if this works ...
CALCULATE([project_cost_total],
FILTER(ALLSELECTED(effective_date),
effective_date[Date] <= MAX(effective_date[Date])
)
)
Or
CALCULATE([project_cost_total],
FILTER(ALL(effective_date),
effective_date[Date] <= MAX(effective_date[Date])
)
)
yes, AllSELECTED formula works! Also, I made a booboo with date format. (facepalm)
thank you.
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 |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
75 | |
51 | |
46 | |
16 | |
12 |