cancel
Showing results for
Did you mean:
Highlighted
Helper II

## If function

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: If function

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

Regards

Miguel Félix

Proud to be a Datanaut!

Check out my blog: Power BI em Português

2 REPLIES 2
Super User III

## Re: If function

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

Regards

Miguel Félix

Proud to be a Datanaut!

Check out my blog: Power BI em Português

Helper II

## Re: If function

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

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors