Forum Discussion
EnderWiggin
Helper I
Helper IRunning total calculation without filter?
Hi All, I created a running total calculation which counts from a start balance. The start balance contains the actual stock quantity, stock input output quantity before the actual month + actual mo...
OK I think I found it, add "<" to this measure
Looking good!
EnderWigginHelper I
Helper II downloaded the file and checked again but unfortunately your solution (in m_StockIORunningTotal) provides same result as the m_StockIODiffForRunningTotal which counts the start balance for running total. The 3rd visualization shows the running total correctly but the 0BeforeActual column is missing:
Please see the details in this RunningTotalDemoWithCalendar1_aj1973
file.
aj1973
Community Champion
Community ChampionHey,
If i use the logic you used in your measure i get this
Is it correct!
the difference resides in your measure when you use [m_ActualMonth]
where is that measure coming from? can't find it anywhere!
it is like the measure is coming from a different table, which is not correct inside the FILTER.