If function

[CTan42]

Hi belows are my screenshot of dataset. I have to create a column/measure to show whether the numbers are matching anot. I was thinking about using if function in power bi. This formula just come across on my mind - delta = if( A profit = B profit C profit, "Match", "Not Match").  However it doesnt work. Is there anyway to do it?excel datapower bimatrix tablesomething like this...however it goes wrong

[MFelix · Accepted solution]

Hi @CTan42,

Even in Excel you cannot do it in a single run as you show in your prints, in term of PBI I prefer to use the SWITCH function that is much more powerfull than the IF because you can concatenate several IF in one row use this measure:

Match validation =
SWITCH (
    TRUE (),
    SUM ( Table1[A Profit] ) = SUM ( Table1[B Profit] )
        && SUM ( Table1[A Profit] ) = SUM ( Table1[C Profit] ), "Match",
    "No Match"
)

The result is below:

Regards,

MFelix

[CTan42]

@MFelix It works!!! Thanks for your help and guide.