Forum Discussion

dbehara's avatar
dbehara
Frequent Visitor
5 years ago
Solved

Concate with if statement

Hi Team,

 

could anyone please help me with power Bi query for below (tableau query)

If [P and C match] + [P and F match] + [C and F match] = 'YYY' Then 'Match' else 'Mis-match' end

 

basically every column [P and C match], [P and F match],[C and F match] has "Y"/"N" values im trying to do an analysis, if all columns are "Y" then Match else Mis-match

 

Thanks for help 🙂

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    dbehara Here is yet another way more based on the original formula:

    IF([P and C match] & [P and F match] & [C and F match] = "YYY","Match","Mis-match")

    & is the concatenation operator, && is logical AND operator.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    dbehara Perhaps in DAX

     

    IF([P and C match] = "Y" && [P and F match] = "Y" && [C and F match] = "Y","Match","Mismatch")

Or maybe:

IF([P and C match] = [P and F match] = [C and F match] = "Y","Match","Mismatch")

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    dbehara Here is yet another way more based on the original formula:

    IF([P and C match] & [P and F match] & [C and F match] = "YYY","Match","Mis-match")

    & is the concatenation operator, && is logical AND operator.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi dbehara,

    You can try using following Dax,
    IF([P = C] && [P = F] && [C = F], "Match","Mis-Match")

    Hope this will help!

    Thanks,
    Ashwin Kulkarni