Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
I want to add column for follwing formula. The status showed "Operator or expression "()" is not in this context
New Column Overall rating
IF(
ISBLANK([Column], BLANK(),
IF(AND([Column1] = "1" && [Column2] = "1" && [Column3]= "1"), "1",
IF(AND([Column1] = "2" && [Column2] = "2" && [Column3] = "2"),"2",
IF(AND([Column1] = "3" && [Column2] = "3" && [Column3] = "3"),"3","0"
)
)
)
Or should i use other filter ?
Thanks in advance
SWEZIN
Solved! Go to Solution.
Hi @Anonymous ,
Create a Calculated Column
Calculated Column =
SWITCH (
TRUE (),
'Table'[Column1] = "1"
&& 'Table'[Column2] = "1"
&& 'Table'[Column3] = "1", "1",
'Table'[Column1] = "2"
&& 'Table'[Column2] = "2"
&& 'Table'[Column3] = "2", "2",
'Table'[Column1] = "3"
&& 'Table'[Column2] = "3"
&& 'Table'[Column3] = "3", "3",
'Table'[Column1]
= BLANK ()
|| 'Table'[Column2]
= BLANK ()
|| 'Table'[Column3]
= BLANK (), BLANK (),
"0"
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Anonymous ,
Create a Calculated Column
Calculated Column =
SWITCH (
TRUE (),
'Table'[Column1] = "1"
&& 'Table'[Column2] = "1"
&& 'Table'[Column3] = "1", "1",
'Table'[Column1] = "2"
&& 'Table'[Column2] = "2"
&& 'Table'[Column3] = "2", "2",
'Table'[Column1] = "3"
&& 'Table'[Column2] = "3"
&& 'Table'[Column3] = "3", "3",
'Table'[Column1]
= BLANK ()
|| 'Table'[Column2]
= BLANK ()
|| 'Table'[Column3]
= BLANK (), BLANK (),
"0"
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Anonymous , isblank not closed properly, but try switch
switch( true(),
ISBLANK([Column]), BLANK(),
AND([Column1] = "1" && [Column2] = "1" && [Column3]= "1"), "1",
AND([Column1] = "2" && [Column2] = "2" && [Column3] = "2"),"2",
AND([Column1] = "3" && [Column2] = "3" && [Column3] = "3"),"3"
,"0"
)
Hi @Anonymous ,
Your DAX expression doesn't seem to be correct. Based on the limited information, try modifying it as follows:
IF(
ISBLANK([Column]), BLANK(),
IF([Column1] = "1" && [Column2] = "1" && [Column3]= "1", "1",
IF([Column1] = "2" && [Column2] = "2" && [Column3] = "2","2",
IF([Column1] = "3" && [Column2] = "3" && [Column3] = "3","3","0"
)
)
)
)
I am not sure why you were using AND operator with && operator. Also, your ISBLANK() brackets were not closed correctly.
If the above DAX doesn't work, then detail your requirement.
Thanks,
Pragati
@Anonymous ,
The and function gets 2 parameters. Use nested and's or &&, not both together.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |