PQ Solution:Filter by 2 lists (Columns) use "M" CODE (List.Max-Table.IsEmpty-if Statement) (PQC04)
Channel: AAA Excel’s Power
Date: 2022-11-02

#excel #exceltutorial  #powerquery 
--------------------------------------------------------------------
0:00 Intro & reimder of the challenge
3:13 Table.SelectRows + List.Contains
10:08 Table.IsEmpty + if Statement
14:43 Solution using flags: List.Max + if statement
23:09 Wall of fame and thank you 
--------------------------------------------------------------------
To download the excel file:
https://drive.google.com/drive/folders/1ciuPu-FR_gbYyyA5374UMl1S5TtuuLwk?usp=share_link
----------------------------------------------------
To subscribe:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1
----------------------------------------------------
To follow on Facebook:
https://www.facebook.com/excelispower
----------------------------------------------------
To follow on LinkedIn:
https://www.linkedin.com/in/amratef