Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dears,
I have two tables , goods recieved in the warehouse and goods delivered into stores.
Need to identify the numbers of days taken to deliver the items from ware house to stores.
untill the stock clear we need to deliver the previous stock : first in first out policy
how can we do it BI?
@Irshadn03 Well, would need sample data posted as text but this is likely going to involve a DAX "while" loop, something like Days of Supply, Delivery Dates, etc.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Delivery-Dates/td-p/2316708
https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/m-p/635656#M318
Thank you @Greg_Deckler , attched sample file for your reference
https://albatha-my.sharepoint.com/:u:/r/personal/irshad_n_mpchealthcare_com/Documents/Irshad/Sample....
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |