Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |