cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 4th column based on 3 columns containing yes or no

Hello I am trying to create 4th column of yes or no based on 3 columns with yes and no in them:

Latest award =

var col1 = 'award'[gold]

var col2 = 'award'[silver]

var col3 = 'award' '[bronze]

return

IF(col1&&col2&&col3 = "No", "No", "Yes")

This creates an error though:

cannot convert value 'yes' of type Text to type True/False

Any ideas how to change please?

3 REPLIES 3
Community Support

Hi @G0ggs

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Super User

Hello @G0ggs ,

Platinium = IF(Award[Bronze]="No" && Award[Gold]="No" && Award[Silver]="No","No","Yes")    As Calculated Column.

Latest Award = IF(MIN(Award[Bronze])="No" && MIN(Award[Gold])="No" && MIN(Award[Silver])="No","No","Yes")    AS Measure Column.

I think above one of solution is helpful for you.

Resident Rockstar

Hi @G0ggs

Latest award =

var col1 = 'award'[gold]

var col2 = 'award'[silver]

var col3 = 'award' '[bronze]

return

IF(col1 = "No" && col2 = "No" && col3 = "No", "No", "Yes")

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

-----------------------------------------------------

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.