Cumulative line chart

[ObdidianMagne]

Hi all, 

I'm trying to built a cumulative line chart for gwp by date but up to now I haven't made it

I use this measure 

measure =

var maxdate=MAX('ΝΒ_pivot_CY'[date])

RETURN

CALCULATE(

    SUM('ΝΒ_pivot_CY'[gwp]),

    'ΝΒ_pivot_CY'[date]<=maxdate,

    ALL('ΝΒ_pivot_CY'[date]))

However I get a chart like this

I also tried the quick measure in pwoer bi for running total but no luck

gwp running total in date =

CALCULATE(

    SUM('ΝΒ_pivot_CY'[gwp]),

    FILTER(

        ALLSELECTED('ΝΒ_pivot_CY'[date]),

        ISONORAFTER('ΝΒ_pivot_CY'[date], MIN('ΝΒ_pivot_CY'[date]), ASC)

    )

)

My data table looks like this. It has repeating date values so I don't know if this

causes the problem

Could you help please?

[lbendlin · Accepted solution]

Most of the time this is caused by a hidden sort column that you forgot to include.

Try

measure =

var maxdate=MAX('ΝΒ_pivot_CY'[date])

RETURN

CALCULATE(

    SUM('ΝΒ_pivot_CY'[gwp]),

    ALLSELECTED('ΝΒ_pivot_CY').

    'ΝΒ_pivot_CY'[date]<=maxdate

    )

[Greg_Deckler · Accepted solution]

@ObdidianMagne Yeah, why you shouldn't use CALCULATE or really any of the default quick measures. There are better ways. Better Running Total - Microsoft Fabric Community.

Here's a playlist: https://www.youtube.com/playlist?list=PLoibEIc7heYNZbnY4CTCtg2tjEcMh8WbZ

And the main video you need.

[Ashish_Mathur · Accepted solution]

Hi,

Create a Calendar table with calculated column formulas for Year, Quarter, Month name and Month number.  Sort the Month name column by the Month number.  Create a relationship (many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table.  To your line chart visual, drag Year, Quarter and Month name columns from the Calendar Table.  Write these measures

Total = SUM('ΝΒ_pivot_CY'[gwp])

Running total = calculate([Total],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))

Hope this helps.

[Greg_Deckler · Accepted solution]

@ObdidianMagne Yeah, why you shouldn't use CALCULATE or really any of the default quick measures. There are better ways. Better Running Total - Microsoft Fabric Community.

Here's a playlist: https://www.youtube.com/playlist?list=PLoibEIc7heYNZbnY4CTCtg2tjEcMh8WbZ

And the main video you need.

[lbendlin · Accepted solution]

Most of the time this is caused by a hidden sort column that you forgot to include.

Try

measure =

var maxdate=MAX('ΝΒ_pivot_CY'[date])

RETURN

CALCULATE(

    SUM('ΝΒ_pivot_CY'[gwp]),

    ALLSELECTED('ΝΒ_pivot_CY').

    'ΝΒ_pivot_CY'[date]<=maxdate

    )