using regular excel formulas in powerpivot manage data

Is there a way I can create a calculuated column in powerpivot with the following formula? When I use it in regular excel it freezes the sheet.

=IF(ISNUMBER(MATCH(A2, $A$1:$A1, 0)), "Dupe", "")