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...
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
