I would like to
Compare two worksheets( Giacenzetoday and Giacenzetoday2- see attached files)
to find
- How many product are in the worksheet Giacenzetoday2 and not in Giacenzetoday (new products)
- How many product are in both of them Giacenzetoday2 and in Giacenzetoday (products in stock)
- How many product are not in both of them Giacenzetoday2 and in Giacenzetoday (products processed)
I think I understand, with POWER QUERY, how to calculate point 1, 2 and 3
My first big problem now is to make this comparison dynamic (Giacenzetoday3 with Giacenzetoday2 – Giacenzetoday4 with Giacenzetoday3 an so on… ) with a lot of comparisons between two worksheets (day by day or moment to moment…because the flux of product flow is continuos )
And mostly
Add up dynamically the list of product
- New (all the new from the first worksheet to the last worksheet)
- In stock (all the product yet in stock from the first worksheet to the last worksheet)
- Processed (all the product processed from the first worksheet to the last worksheet)
Too much for Power Query????
Thank you all
maybe PQ it's not the right path?
Indeed PQ is not the right way. Power Pivot is the way to go, PQ will have to combine all worksheets data to pass it to Power Pivot. There you can set measures to calculate, there are lots of ready made measures on web that fits to your scenario.
Catalin Bombea said
Indeed PQ is not the right way. Power Pivot is the way to go, PQ will have to combine all worksheets data to pass it to Power Pivot. There you can set measures to calculate, there are lots of ready made measures on web that fits to your scenario.
Hi Catalin,
I' m very newbie about PQ e PP.
Could you tell me where could I find some exemples of these " ready made meausures"?
Thanks in Advance
Stefano
Hi Stefano,
Try this site: https://www.daxpatterns.com/cumulative-total/
If that page doesn't have it, keep searching that site as it is an excellent resource for DAX measures.
Mynda
