Find unique value in two columns

[lpd82]

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

[amitchandak · Accepted 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())

[lpd82]

Perfect!  Thank you.