Forum Discussion
IF /AND statements
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
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!
5 Replies
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 ,
The and function gets 2 parameters. Use nested and's or &&, not both together.
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 , 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" )
