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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

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.