Forum Discussion
Power Pivot Filters
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. 🙂
Hi 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
Again, if you could post some sample data that is representative or your actual data (same columns, enough rows to work with, etc) it would help us. Just writing a paragraph about your data layout isn't helping me see your model very well. Tables are worth a thousand words. 😁
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 ForumPlease see below my test data for the GRN table.
I need the ability to include in my pivot table the last receipt date for a Product and the Qty received, in the location UK or US.
I can work it out for Total Qty received by product by location, just escapes me how to get the qty for the last receipt date.
Thanks
Sam
Product Location GRN Qty Supplier Receipt Date LK-049 UK GR 223 20 Howhot 10/07/2020 LK-049 US GR 224 5 Howhot 11/07/2020 LK-047 UK GR 223 20 Howhot 10/07/2020 LK-047 US GR 224 5 Howhot 11/07/2020 LK-048 UK GR 223 20 Howhot 10/07/2020 LK-049 UK GR 225 20 Howhot 14/07/2020 LK-049 UK GR 123 20 Howhot 10/06/2020 LK-049 US GR 124 5 Howhot 11/06/2020 LK-047 UK GR 123 20 Howhot 10/06/2020 LK-047 US GR 124 5 Howhot 11/06/2020 LK-048 UK GR 123 20 Howhot 10/06/2020 LK-049 UK GR 125 20 Howhot 14/06/2020