Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |