Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |