Forum Discussion

FZOU's avatar
FZOU
Helper IV
6 years ago
Solved

Running total

Hello community,   I need your help lease is such a problem i'm calculating a running total it's work fine but with a weird comportment. Until the above picture everything is ok but when i m...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    FZOU 

    if you use allselected it will take the selected dates , you can use all or datestyd as per need

     

    Cumul = CALCULATE(SUM(Demand[DemandQt]);FILTER(ALL(demand);Demand[Sales Date]<=max(Demand[Sales Date])))

    Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date])

    Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date],"1/31")// force year from Feb

amitchandak's avatar
amitchandak
Super User
6 years ago

FZOU 

if you use allselected it will take the selected dates , you can use all or datestyd as per need

 

Cumul = CALCULATE(SUM(Demand[DemandQt]);FILTER(ALL(demand);Demand[Sales Date]<=max(Demand[Sales Date])))

Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date])

Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date],"1/31")// force year from Feb