Forum Discussion
Cumulative Total
Hi Team, I am trying to create coulumn contain cummlative total of quantites(MGO1) and there are two conditions which i need to full fill: If delivery date <=today(week num) then i just want cu...
Is this what you are looking for?
I made some updates, try the following steps:
1- Create a new calculated column and paste the code bellow
1- Create a new calculated column and paste the code bellow
Column =
VAR sumUntillToday =
CALCULATE(
SUM(Your_Sales_Column),
FILTER(
ZIBP_PO_MGRTN,
ZIBP_PO_MGRTN[DELIVERY_DATE] <= TODAY()
)
)
VAR result =
IF(
ZIBP_PO_MGRTN[DELIVERY_DATE] <= TODAY(),
sumUntillToday,
Your_Sales_Column
)
RETURN
result
2- In your column tools, keep summarization as "Minimum"
3- Drag the new column into your Matrix
HI Bibiano_Geraldo ,
I appreicate your help and your quick response. I tried and created the column as suggested by you but problem is same it's doing the sum of whole column due to that i am getting wrong value.If we can create this as a measure then only it will work .
Please see below :
Our values should appear as cummulative total untill 26/09/23 will be 200. and if date is future it will only show 25.
| Matnr | Date | MNGO1 | Expected Cummulative Result |
| 1234567 | 26-07-23 | 100 | 100 |
| 1234567 | 26-08-23 | 50 | 150 |
| 1234567 | 26-09-23 | 50 | 200 |
| 1234567 | 26-02-2024 | 25 | 25 |