Forum Discussion
Running sum with Period
Dear experts, I have a situation where I wanted to show the running total in a line chart for Actuals, Expected, and Variance, we are able to get the values and create the visual. But having a s...
Anonymous Thank you for your great ideas.
ibarrau Thank you for your replies, I tried the formula you gave me but it did not work. To make the things simple I created a simple table visual. Then I created a Running sun measure for actuals. The following is the screenshot of it. I want to stop showing the running total from Period 6 onwards. How can I do it.
Following is the formula I have for the running total
ACTUAL running total in MONTH =
CALCULATE(
SUM('Burn'[ACTUAL]),
FILTER(
ALLSELECTED('Burn'[MONTH]),
ISONORAFTER('Burn'[MONTH], MAX('Burn'[MONTH]), DESC)
)
)
Osmand
Hi there. If you really had taken my advice seriously, you'd now know how to do such a thing:
https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/
Best
D
https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/
Best
D
Thank for your article I am trying to apply your solution but I am still unable to get it correct.
Osmand
- That's because you are not following Best Practices. Please have a look at how to correctly apply time intelligence in a model:
https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/
Best
DThank you for your support
- You will not be getting things right until you have a correct model where there are separate date/time dimensions.
Best
D
