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.
I'm creating a column with 'And' ,'Multiple Conditions'
Co = IF(AND([RRR]=1, [Highest]="Rer"),1,0)
Solved! Go to Solution.
Hi. Try this...
IF(
AND(
[RRR] = 1,
[Highest] IN {"Rer", "Con", "EC"}
),
1,
0
)
@devika , if you are trying on power Query/M
Co = if [RRR]=1 and ([Highest]="Rer" or [Highest]="Con" or [Highest]="EC") then 1 else 0
or
Co = if [RRR]=1 and [Highest] in {"Rer" , "Con" ,"EC" } then 1 else 0
In DAX a new column
Co = IF([RRR]=1 && [Highest] in {"Rer" , "Con" ,"EC" } , 1 , 0)
I managed to solve by Switch(true(), [rrr]=1 && [Highest] ="Rer",1,[rrr]=1 && [Highest] ="Con",1,0)
I will yours solution too and post it here. thanks for you reply
Hi. Try this...
IF(
AND(
[RRR] = 1,
[Highest] IN {"Rer", "Con", "EC"}
),
1,
0
)
Something around IN Operator is not right.
Getting Token Comma Expected error... not sure what is missed
Can you paste your code? I tried it in another project and worked perfectly
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |