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 Forum
