Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Boolean calculated column

Hi 

 

How to write boolean calculated expression when 

1)Calcuated column A : "Column 1 & Column 2  equal to value ='A' else 'No'

2)Calculated Column B: Column 1 & Column2  not equal and is null  then 'Yes' else 'o'

 

Vs

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anonymous 

Two Columns:

Column A = IF( Table[Column1] = Table[Column2] ,"A" , "NO")

Column B = IF( ISBLANK(Table[Column1]) && ISBLANK(Table[Column2] ), "YES", "O")  

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

How to convert boolean datatype as text datatype for Calculated column in Power Bi?

Fowmy
Super User
Super User

@Anonymous 

Two Columns:

Column A = IF( Table[Column1] = Table[Column2] ,"A" , "NO")

Column B = IF( ISBLANK(Table[Column1]) && ISBLANK(Table[Column2] ), "YES", "O")  

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors