Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |