Forum Discussion
Tango2310
Helper I
Helper ICompound Values
Hi, New to Power BI. I have a table of date an invoice values and am trying to work out how to make the line compound in other words build on the totals to the left. In other words 1s...
Hi Tango2310 ,
please refer below video to create running total measure using DAX :
https://www.youtube.com/watch?v=NBGGHdKxupk&t=347s
use that measure to plot your graph.
let me know if this works for you or share additional details for your requirement.Thanks,
Ankita
TrevLc
Helper III
Helper IIIYou can use visual level calculations to create a running sum formula, or you can create a measure like this:
running sum =
CALCULATE(sum('Table'[Amount]),
FILTER (
ALL ( 'Table' ),
'Table'[Date] <= MAX ( 'Table'[Date] )
))
