Cumulative Total Issue

[Dora]

Hi All,

I need to Calculate cumulative liability,I used following formula

Custom Liability Cumulative This Year = CALCULATE([Liability This Month],FILTER(ALL(GL_LEDGER_ACCESS[Date]),'GL_LEDGER_ACCESS'[Date]<=MAX('GL_LEDGER_ACCESS'[Date])))

I get same output as shown in image

Please Help.

Best Regards,

Dora

[v-yuezhe-msft]

@Dora,

Create a date table following the guide in this blog, establish relationship between the date field of date table and GL_LEDGER_ACCESS'[Date] field, then update your DAX to the following:

Custom Liability Cumulative This Year = CALCULATE([Liability This Month],FILTER(ALL('Date'[Date]),'Date'[Date]<=MAX('Date'[Date])))

Regards,
Lydia

[Dora · Accepted solution]

Hi All,

Thank You for the help.Solved it by making a new unique index column and making the same formula

Best Regards,

Dora

[edejes2]

Hello @Dora,

This will help you https://www.youtube.com/watch?v=hH_uiw7f900 

Regards!

ED