Forum Discussion
Running Total not working
Hi all! I'm new to Power BI and I'm trying to make a running total of the column 'Projection Base' based on a Date column. In this example, Projection Base is a measure as follows: 3. Projec...
Hi,
Does this measure work?
=CALCULATE([3. Project base],DATESBETWEEN(Calendar[Date],MINX(ALL(Calendar),Calendar[Date]),MAX(Calendar[Date])))
Just ensure that in your visual, the Year and Month should be dragged form the Calendar Table.
Hope this helps.