I have daily transaction for multiple model and date ,would like to get each model's last value of the each month . Eg, if last date of product A is 5/18/2022 then May's Closing inventory value will be 15 and 1453.
The table i have
Date | Product Name | Qty | Amount |
5/18/2022 | A | 15 | 1453 |
5/30/2022 | A | 17 | 1152 |
6/11/2022 | A | 14 | 1627 |
7/18/2022 | A | 11 | 1561 |
4/26/2022 | B | 10 | 1774 |
5/4/2022 | B | 16 | 1631 |
5/13/2022 | B | 13 | 1440 |
5/20/2022 | B | 16 | 1110 |
6/7/2022 | B | 16 | 1817 |
6/10/2022 | B | 14 | 1991 |
6/13/2022 | B | 20 | 1469 |
6/13/2022 | B | 14 | 1467 |
6/22/2022 | B | 11 | 1150 |
7/9/2022 | B | 12 | 1013 |
The result i would like to get
Date | Product Name | Qty | Amount | Closing Inventory per month | Closing Inventory Value |
5/18/2022 | A | 15 | 1453 | 15 | 1453 |
5/30/2022 | A | 17 | 1152 | 17 | 1152 |
6/11/2022 | A | 14 | 1627 | 14 | 1627 |
7/18/2022 | A | 11 | 1561 | ||
4/26/2022 | B | 10 | 1774 | 10 | 1774 |
5/4/2022 | B | 16 | 1631 | ||
5/13/2022 | B | 13 | 1440 | ||
5/20/2022 | B | 16 | 1110 | 16 | 1110 |
6/7/2022 | B | 16 | 1817 | ||
6/10/2022 | B | 14 | 1991 | ||
6/13/2022 | B | 20 | 1469 | ||
6/13/2022 | B | 14 | 1467 | ||
6/22/2022 | B | 11 | 1150 | 11 | 1150 |
7/9/2022 | B | 12 | 1013 | 12 | 1013 |
Solved! Go to Solution.
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0PyTPZiaKKYMUc9?e=wyuSUJ
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0PyTPZiaKKYMUc9?e=wyuSUJ
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
124 | |
76 | |
69 | |
54 | |
53 |
User | Count |
---|---|
191 | |
104 | |
83 | |
79 | |
78 |