Concate with if statement

[dbehara]

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 🙂

[Greg_Deckler · Accepted solution]

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

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

[Greg_Deckler]

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