Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

backlog pivot

Hello All,   I have a pivot table, i need to add the backlog in the calculation: example: The first value before October-2019 need to be  6134 after that i add and decrease the other data. ...
Help me please
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

Cumm Stock = 6314 + CALCULATE(SUM(Sum[ENTRATE]),filter(date,date[date] <=maxx(date,date[date]))) -CALCULATE(SUM(Sum[CHIUSE]),filter(date,date[date] <=maxx(date,date[date])))44

Cumm Stock = 6314 + CALCULATE(SUM(Sum[ENTRATE]),filter(date,date[date] <maxx(date,date[date]))) -CALCULATE(SUM(Sum[CHIUSE]),filter(date,date[date] <maxx(date,date[date])))

 

If case you do not have the date , create a date from the month

https://youtu.be/cJqgphIHXz8