IF condition two table column comparison

[Shanvitha_V]

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

[tamerj1 · Accepted solution]

Hi @Shanvitha_V 

please try

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

[tamerj1]

Hi @Shanvitha_V 

are creating a calculated column in Table A?

[Shanvitha_V]

tamerj1,

Good day,

I have creating Table B as Calculated column

[tamerj1]

@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]

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