Forum Discussion

Dora's avatar
Dora
Helper I
8 years ago
Solved

Cumulative Total Issue

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_LEDGE...
Need Help
  • Dora's avatar
    Dora
    8 years ago

    Hi All,

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

    Best Regards,

    Dora

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Dora
Helper I
8 years ago

Hi All,

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

Best Regards,

Dora