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
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Shanvitha_V 

are creating a calculated column in Table A?

  • 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
      Icon for Community Champion rankCommunity 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?

      • Shanvitha_V's avatar
        Shanvitha_V
        Frequent Visitor
        4 years ago

        tamerj1,

        yes.

         

        or

         

        My requiredment is below I need DAX formula

         

        who patients who have operation discharge same day

        I have columns like admitteddate,Dischargedate in TableB

        TableA Name= TableB Name

        Table age >18