Value of last transaction values for each model and each month

[PhyuLayKhine333]

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

[mangaus1111 · Accepted solution]

Hi @PhyuLayKhine333 

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.