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 throughing error.

 

My Condition:

who patients who have operation discharge same day

I have columns like admitteddate,Dischargedate in Table

TableA Name= TableB Name

Table age >18

 

I have given relationship two table TableA Date and TableB Admitteddate

 

Please anybody help

 

Thnaks

Shanvitha_V

 

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
)

5 Replies

  • 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
)
    • Shanvitha_V's avatar
      Shanvitha_V
      Frequent Visitor
      4 years ago

      tamerj1,

      Good day,

      I have creating Table B as Calculated column

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Shanvitha_V 

        So what is your ultimate goal? Do you want to check if the name in the current row of tableB exist the name column of tableA?