Forum Discussion

Dora's avatar
Dora
Icon for Helper I rankHelper 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_LEDGER_ACCESS'[Date]<=MAX('GL_LEDGER_ACCESS'[Date])))

 

I get same output as shown in image

Please Help.

Best Regards,

Dora

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

3 Replies

  • 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
      Icon for Helper I rankHelper 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