Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |