Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

 

 

 

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

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!

View solution in original post

5 REPLIES 5
harshnathani
Community Champion
Community Champion

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!

amitchandak
Super User
Super User

@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"

)

 

Anonymous
Not applicable

@amitchandak 

The formula still have error with following message. 

SWEZIN_0-1594134550076.png

 

Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

camargos88
Community Champion
Community Champion

@Anonymous ,

 

The and function gets 2 parameters. Use nested and's or &&, not both together.

 

https://docs.microsoft.com/pt-br/dax/and-function-dax



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.