Forum Discussion
How to count balance for replenish ?
Hi fyong
You can refer to the following measure
Balance_ = [PO QTY] - SUMX ( FILTER ( ALLSELECTED ( 'Demand Table' ), [Item ] IN VALUES ( 'Demand Table'[Item ] ) && [Ordered_Date] <= SELECTEDVALUE ( 'Demand Table'[Ordered_Date] ) ), [Demand QTY] )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHey fyong ,
now I'm able to download, the file, but still there is not explanation on how to create the values in the expected output column. Without providing business rules, it's not possible to create any DAX.
For me the information you provided so far is not sufficient, for this reason, I will not be able to help you on this question.
Regards,
Tom
Hi Tom ,
Actually i want to know what is the shortfall quantity day to day comparing to customer demand and On hand stock ( Open PO &Inventory).
The similarity is the item number .
Hi fyong
You can refer to the following measure
Balance_ = [PO QTY] - SUMX ( FILTER ( ALLSELECTED ( 'Demand Table' ), [Item ] IN VALUES ( 'Demand Table'[Item ] ) && [Ordered_Date] <= SELECTEDVALUE ( 'Demand Table'[Ordered_Date] ) ), [Demand QTY] )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yolo Zhu,
Thanks for the solution . I really appreciate it .
Hi Yolo Zhu ,
My balance is incorrect if i have mutliple orders within the same day. DO you have any idea to solve this ? I have attached link for your reference
https://drive.google.com/file/d/1DoUxzzaPoWpg3NveGspznJokypGygsHU/view?usp=drive_link