Running Total Problem

[timknox]

Hi,

I am trying to create a stacked graph of a running total, but I am having great problems.

What i am trying to get is a graph like this:

but i am getting this:

I have a sample PBIX file here:

Grateful if someone can help me please

[amitchandak]

@timknox , try a measure like

CALCULATE(
	SUM(Sheet1[Value]),FILTER(ALL(Sheet1),Sheet1[Date]<=MAX(Sheet1[Date])))

In case you want all only date. Move that to a separate table or use date table

CALCULATE(
	SUM(Sheet1[Value]),FILTER(ALL(DAte),DAte[Date]<=MAX(DAte[Date])))

[timknox]

@ amitchandak

thanks for this but i tried that as per the example PBIX.....

any ideas?

[v-xuding-msft · Accepted solution]

Hi @timknox ,

Please try this:

Create a new date table:

Date = CALENDARAUTO()

Create a measure:

Running Total = 
CALCULATE(
	SUM(Sheet1[Value]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))