Compare 2 columns

[pgalvezt]

Hello,

I need to compare 2 columns.... one of them is a Measure the other column is a Dimension,  both are Text numbers.

Column Measure:

Only({<Mon-={'Beta'},id={'20'},Year,Month,day,Period>}Number)

The dimension Column: 

Number_Id

Column1             Column2     Compare

202030                 202030          True

202035                202035         True

202060                 202070         False

202090                 202025          False

How Can achieve this in set analysis?

Thanks!

[Taoufiq_Zarra · Accepted solution]

@pgalvezt  if I understood correctly you need :

if(Column1=Only({<Mon-={'Beta'},id={'20'},Year,Month,day,Period>}Number),''True,'False')

since in Set analyusis we are going to consider all the data and not line by line