Match in DAX

[ahmedismailfourtex]

Hello
how to check if that name is match found in another table in power pivot (DAX) ?

 

[olivierhbh]

Hello,

If I understand well your request you have two options, if the tables are related, you can use RELATED([target_column_from_other_table]), or else you can try LOOKUPVALUE([target_column_from_other_table], [id_column_from_other_table], [id_column_from_this_table]).

Let me know if it solves your problem.

Olivier.

 

[ahmedismailfourtex]

Great
the second one worked good
thank you