The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
How to convert boolean datatype as text datatype for Calculated column in Power Bi?
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group