Forum Discussion
Power Pivot Filters
I have a table with Goods Receipt data for my products, goinbg back 2-3 years.
Product, Supplier, GRN Number, PO Number, Reciept Date, Quantity Received
I need to show in a report, by product, the last receipt data and quantity received on that date
I am using Power Query and Power Pivot.
Thanks
Sam
Yes, small tweaks, but instead of one measure it is now 4, so rather than post them all here, just grab the PBIX file. It returns a table like this:
I appreciate the candle offer, but I'm just here to help. 🙂
10 Replies
You are going to have to share data, otherwise you'll just get generic answers about using MAX() in a variable for the date, the ALL() function, etc.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumHi SamTaylor ,
I am not clear about your requirements. Do you mean to get an accumulated value or a maximum?
I have a table with Goods Receipt data for my products, goinbg back 2-3 years.
Product, Supplier, GRN Number, PO Number, Reciept Date, Quantity Received
I need to show in a report, by product, the last receipt data and quantity received on that date
I am using Power Query and Power Pivot.
For example, I have a product received on 3 GRNS, one Jan, one Feb and one Mar, each with a qty of 5.
The report needs to show me the last Grn = Mar, the qty received in Mar and if possible the supplier name.
Thanks
Sam
Sorry, to be clear.
I need the data to be available in Power Pivot, so I can create reports from the data.
Cheers
Sam
