Compare second row value with first value in same column

[Anonymous]

HI,

I need create a new column where Comparing second row value with first value in same column. check the below table with result column.

Internal ID	Opty repeat
OP# 01139295	No
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01164669	No
OP# 01164669	Yes
OP# 01164669	Yes
OP# 01164669	Yes
OP# 01164669	Yes
OP# 01164669	Yes
OP# 01139295	No
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes
OP# 01139295	Yes

[camargos88 · Accepted solution]

Hi @Anonymous ,

I've create this file as an example: Download PBIX 

It uses Power Query to create an index for each value, and gives the No to index = 0 on each internal ID.

If you consider it as a solution, please mark as a solution and kudos.

Ricardo