Compare text values with different columns in different tables

[Anonymous]

Hi

I have three  tables.

Table1 : column 1, column2

Table2 : column3, column2

Table3: column4, colum2.

Is there a way as such, i need to compare data as if(table1(column2)=table2(column2) then table2(column) else table table3(column2)) should be displayed in table1(column2). All are text values

[halfglassdarkly · Accepted solution]

It would depend on your table relationships and cardinality how best to achieve this, but I'd start by looking at what you can achieve using RELATED() or LOOKUPVALUE()

see https://learn.microsoft.com/en-us/dax/related-function-dax  and https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax