Forum Discussion

Helper I

2 years ago

Solved

Compound 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...

Need Help

AnkitaaMishra
2 years ago
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

Anonymous

Not applicable

2 years ago

Hi Tango2310 ,

Do you want to find the composite value of the month?

If so, I did a test for your reference.

In my scenario:

My Model View:

Table:

Table 2 =SUMMARIZE('Table','Table'[Date],"sum",SUMX('Table',[Invoice Value]))

My Report View:
my =var _table=SUMMARIZE(ALL('Table'),'Table'[Date],"sum",SUMX('Table',[Invoice Value]))
return
SUMX(FILTER(_table,[Date]<=MAX('Table'[Date])),[sum])