Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @Shanvitha_V
please try
=
IF (
TableB[admitteddate] = TableB[Dischargedate]
&& TableB[age] > 18
&& TableA[name] IN VALUES ( TableB[name] ),
1,
0
)
Hi @Shanvitha_V
please try
=
IF (
TableB[admitteddate] = TableB[Dischargedate]
&& TableB[age] > 18
&& TableA[name] IN VALUES ( TableB[name] ),
1,
0
)
tamerj1,
Good day,
I have creating Table B as Calculated column
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?
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