Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Jameswh91
Helper III
Helper III

Conditional column based on two columns

‎04-27-2022 09:25 AM

Hi,

 

I'm Looking to create an additional true/false column based on 2 separate columns. For example, if the sales price matches the RRP then yes, if it doesn't match then no.

 

Anyone know how i can achieve this?

 

Thannks in advance.

Message 1 of 3
1,697 Views
0
1 ACCEPTED SOLUTION
Vijay_A_Verma
Most Valuable Professional
Most Valuable Professional

‎04-27-2022 09:41 AM

Use following in a custom column (where sales price and RRP are your column names)

= if [sales price]=[RRP] then "Yes" else "No"

 

View solution in original post

Message 2 of 3
1,672 Views
0
2 REPLIES 2
Jameswh91
Helper III
Helper III

‎04-28-2022 12:42 AM

Many thanks! Much appreciated!

Message 3 of 3
1,649 Views
0
Vijay_A_Verma
Most Valuable Professional
Most Valuable Professional

‎04-27-2022 09:41 AM

Use following in a custom column (where sales price and RRP are your column names)

= if [sales price]=[RRP] then "Yes" else "No"

 

Message 2 of 3
1,673 Views
0

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All