Forum Discussion

Shanvitha_V's avatar
Shanvitha_V
Frequent Visitor
4 years ago
Solved

IF condition two table column comparison

Hi Export, Good day, I have two column with two different table how compare in IF condition.   Condition=IF(TableA(Name)=TableB(Name) && age>18,1,0)   TableA(name)=tableB(name)  not compare thr...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Shanvitha_V 

    please try

    =
IF (
    TableB[admitteddate] = TableB[Dischargedate]
        && TableB[age] > 18
        && TableA[name] IN VALUES ( TableB[name] ),
    1,
    0
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Shanvitha_V 

please try

=
IF (
    TableB[admitteddate] = TableB[Dischargedate]
        && TableB[age] > 18
        && TableA[name] IN VALUES ( TableB[name] ),
    1,
    0
)