Forum Discussion

vejas's avatar
vejas
Helper I
8 years ago
Solved

running total DAX

I have related tables - Debt_table ,Calendar   Debt table columns:   Date | Client | Sell/Payment   I calculate running total , to know clients debt balance to date.   Total Debt = CALCULATE(...
Need Help
  • vejas's avatar
    vejas
    8 years ago

    Solution is to run FILTER against Calendar table , not Debt_table.

     

    CALCULATE([Total Sell/Payment],FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<=MAX('Calendar'[Date])))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi vejas,

 

Try this

 

=CALCULATE([Total Sell/Payment],FILTER(ALL(Debt_table[Date]),Debt_table[Date]<=MAX(Debt_table[Date])))

 

Hope this helps.