Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
4 years ago
Solved

Cumulative balance

Hi,   I have a very simple Model:     What i want to do, is have 2 visuals:  1. Date Filter: The user will select a date  2. Table: The table will show the cumulative balance for each ma...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    CarlsBerg999 , I think here you need all

     

    Cumulative Inventory Balance = CALCULATE(SUM('Inventory Balance'[Quantity]),
    FILTER(all(DateTable),
    DateTable[Date]<=SELECTEDVALUE(DateTable[Date])))

     

    or

     

    Cumulative Inventory Balance = CALCULATE(SUM('Inventory Balance'[Quantity]),
    FILTER(all(DateTable),
    DateTable[Date]<=max(DateTable[Date])))

amitchandak's avatar
amitchandak
Super User
4 years ago

CarlsBerg999 , I think here you need all

 

Cumulative Inventory Balance = CALCULATE(SUM('Inventory Balance'[Quantity]),
FILTER(all(DateTable),
DateTable[Date]<=SELECTEDVALUE(DateTable[Date])))

 

or

 

Cumulative Inventory Balance = CALCULATE(SUM('Inventory Balance'[Quantity]),
FILTER(all(DateTable),
DateTable[Date]<=max(DateTable[Date])))