46,186 questions
POWER PIVOT Running total graph breaks?
CorporateEmo
1
Reputation point
Hi, Microsoft. Need help in figuring this out. The above screenshot is the graph I made using PowerPivot and DAX formula. For reference, here's the formula:
=CALCULATE(COUNTA(Actual[Actual - M4]),FILTER(ALLSELECTED(DataDateM4[Date]),ISONORAFTER(DataDateM4[Date],MAXA(Actual[Actual - M4]),desc)))
here's the Pivot Table as well:
The yellow ones are what cause the breakage in the graph. Can you help me figure out the right DAX formula? Thank you
Community Center Not monitored
Sign in to answer