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
Ashish_Mathur
Super User
Super UserHi,
Try this approach
- Create a Calendar table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number.
- Create a relationship from the Date column of the Data Table to the Date column of the Calendar table
- To the X-axis, drag Date from the Date column of the Calendar Table
- Write these measures
Total = sum(Data[invoice value])
RT = calculate([Total],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))
Hope this helps.