Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How do I check for two columns in a single table to see if they match? I need to create a column labeled "Check" to find ID where type A maches type B. TIA
| ID | Type | Check |
| 1 | A | TRUE |
| 2 | A | TRUE |
| 3 | A | TRUE |
| 4 | A | TRUE |
| 5 | A | FALSE |
| 6 | A | FALSE |
| 1 | B | TRUE |
| 2 | B | TRUE |
| 3 | B | TRUE |
| 4 | B | TRUE |
Solved! Go to Solution.
@lpd82 , Try a new column like
new column =
var _id = [ID]
var _Ty = [Type]
var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID)
return
if(isblank(_1), False(), True())
Perfect! Thank you.
@lpd82 , Try a new column like
new column =
var _id = [ID]
var _Ty = [Type]
var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID)
return
if(isblank(_1), False(), True())
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |