Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

Value of last transaction values for each model and each month

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

DateProduct NameQtyAmount
5/18/2022A151453
5/30/2022A171152
6/11/2022A141627
7/18/2022A111561
4/26/2022B101774
5/4/2022B161631
5/13/2022B131440
5/20/2022B161110
6/7/2022B161817
6/10/2022B141991
6/13/2022B201469
6/13/2022B141467
6/22/2022B111150
7/9/2022B121013

 

 

The result i would like to get

DateProduct NameQtyAmountClosing Inventory per monthClosing Inventory Value
5/18/2022A151453151453
5/30/2022A171152171152
6/11/2022A141627141627
7/18/2022A111561  
4/26/2022B101774101774
5/4/2022B161631  
5/13/2022B131440  
5/20/2022B161110161110
6/7/2022B161817  
6/10/2022B141991  
6/13/2022B201469  
6/13/2022B141467  
6/22/2022B111150111150
7/9/2022B121013121013
1 ACCEPTED SOLUTION
mangaus1111
Solution Sage
Solution Sage

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.

View solution in original post

1 REPLY 1
mangaus1111
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.