Use of curly brackets in If formula

[Varinder]

Hello Community

I was trying to use the Excel formula IF(AND(M7="GP01",AI7<>""),"",IF(OR(D7={"Q1",""},M7={"GV01","GL02","GL03","GL07","GF01"}),"",1))

in DAX where curly brackets showing error "A table of multiple values was supplied where a single value was expected."

What are the other ways to use the same formula in DAX?

@TomMartens @amitchandak 

[MFelix · Accepted solution]

Hi @Varinder ,

For this you need to use the in statement rewrite the measure has:

IF(AND(M7="GP01",AI7<>""),"",IF(OR(D7 in {"Q1",""},M7 in {"GV01","GL02","GL03","GL07","GF01"}),"",1))

[TomMartens · Accepted solution]

Hey @Varinder ,

you might try to replace this

M7={"GV01","GL02","GL03","GL07","GF01"}

with this

M7 IN {"GV01","GL02","GL03","GL07","GF01"}

Use th IN operator if a certain value is one of many values.

Hopefully, this provides what you are looking for.

Regards,

Tom

[MFelix · Accepted solution]

Hi @Varinder ,

For this you need to use the in statement rewrite the measure has:

IF(AND(M7="GP01",AI7<>""),"",IF(OR(D7 in {"Q1",""},M7 in {"GV01","GL02","GL03","GL07","GF01"}),"",1))