Solved: Power Pivot Filters - Page 2

SamTaylor · ‎07-10-2020

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

edhans · ‎07-14-2020

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. 🙂

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Power Pivot Filters