Forum Discussion
Compare text values with different columns in different tables
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
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
1 Reply
halfglassdarklyResponsive Resident
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