Forum Discussion
Filter based on values from other query
I'm trying to filter a column based on the values from another query or List. Step 1: Filter Column 1 = null - = Table.SelectRows(#"Expanded Sheet1 (2)", each ([JOURNAL_NAME] = null)) Ste...
Hi The_Stein ,
I agree with ImkeF . When you need to do something based on other tables , the easiest way is to Merge these tables then expand columns , and after doing transformation , remove the unnecessary columns.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.