Forum Discussion
Running Total of a Complex Measure
I'm attempting to calculate a running total based off a complex measure. The measure is made using a series of calculations off a table in PowerPivot. I've imported the data set to PowerBI and I want...
Look at replacing your ALL with ALLEXCEPT.
Greg_Deckler
Community Champion
Community ChampionLook at replacing your ALL with ALLEXCEPT.
That worked perfectly, thank you.
Would you have any idea how to produce the 2017 line? Ideally it would be the filtered year - 1 so that it automatically switches year to year.
- Greg_Deckler
See if my Time Intelligence the Hard Way provides a method of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Thank you once again.