Power Query Challenge 14: Identify All-Season Products - Solving with List.Difference

[@IvanCortinas_ES]

Excellent solutions Omid. Very well explained. Thank you very much!

[@PowerMquery]

You are welcome

[@Excelambda]

Great video!! Great solution!!
Alternative:
- since had no data , if "m", date vect and "p" products vector
=LET(t,LEFT(UNIQUE(p&MONTH(m))),g,GROUPBY(t,t,COUNTA,,0),FILTER(g,TAKE(g,,-1)=12))

[@PowerMquery]

Greate

[@omarnader776]

good and easy explanation, thanks

[@PowerMquery]

You are welcome!

[@kkravch]

Thanks a lot, good and informative. I have a question though -- if one needs to do it on a large dataset, which option would give better performance -- large nested formula vs several simple steps? Thanks.

[@PowerMquery]

It's depend to the example but usually simple steps comes with better performance and to improve it Table.Buffer and List.Buffer are handy.

[@kkravch]

@@PowerMquery Thank you