Forum Discussion

SamTaylor's avatar
SamTaylor
Helper I
6 years ago
Solved

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...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    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. ðŸ™‚

     

SamTaylor's avatar
SamTaylor
Helper I
6 years ago

edhans 

 

OMG, it's excellent. I thought I might be able to pick up some Dax learning on the side but it's way above me.

I have applied it to the test table below and the result is in the pivot below that. (see image)

 

But now I am fealing guilty as I need a minor amend, due to my lack of clarity at the start.

 

I need the UK and US results to be in separate measures, as in the green table.  Is this a quick change?

 

Also, my wife makes candles, can I send you one as a gift?

see www.wrightandgreen.co.uk for a selection of scents.

 

Thanks

Sam

 

 

 

edhans's avatar
edhans
Community Champion
6 years ago

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. ðŸ™‚