Creating new Power BI Table by filtering values from another table column

[@pravinshingadia7337]

Brillaint - thank you my friend!

[@蘇子欽-b2u]

Hello Abhishek, is it possible to input “P01,P02,P04” by the user dynamically?

[@criztina]

is it possible to use Filter with non-related tables? I created a table from an excel with many columns and rows to be used as filters as there are many conditions and I can't make it work.

[@nidhisingh4973]

Hello Abhishek, Thank you for all your nice videos. This solution works only if filter direction from many to one bcz related function pass the information from M to 1 direction. Is there anyway to do this filtering from 1-M side (ex :FILTER(table1 , table1[column]=tableM[column])). Table1 : Present at 1 side of relationship. TableM : Present at M side of relationship.