Forum Discussion

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
4 years ago

Calculate incremental quantity month by month

Hi everyone. I've got this table which shows quantities entering and exiting the warehouse, month by month. In the first row I have the initial stock of the first day of 2021 and I want to create t...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mtrevisiol , A new measure

 

Sum(Table[Initial Stock]) + Sumx(filter(all(Table), [Item] = Max(Table[Item]) && [Date] <= Max(Table[Date]) ), Table[Qty] )

 

 

or

new column =
Table[Initial Stock] + Sumx(filter((Table), [Item] = earlier(Table[Item]) && [Date] <= earlier(Table[Date]) ), Table[Qty] )

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
4 years ago

I created the new column using your formula, but I didn't get what I needed..