Forum Discussion

AishwaryaS's avatar
AishwaryaS
Frequent Visitor
5 years ago
Solved

Dynamic Running Total

Hi, I want to calculate cumulative sum of quantity based on each material considering date, ID and Item columns, and also while a slicer filter is selected the cumulative sum must dynamically change ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    AishwaryaS , Try a measure like

    calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Material] = max(Table[Material]) && Table[Date] <= max(Table[Date])))

amitchandak's avatar
amitchandak
Super User
5 years ago

AishwaryaS , Try a measure like

calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Material] = max(Table[Material]) && Table[Date] <= max(Table[Date])))

Brinki's avatar
Brinki
Frequent Visitor
3 years ago

Hello Amit,

And what about last year?

I'm trying to make it dynamic without year filters.

 

Thanks,

Stephen