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 ...
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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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")