Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compare second row value with first value in same column

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 IDOpty repeat
OP# 01139295No
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01164669No
OP# 01164669Yes
OP# 01164669Yes
OP# 01164669Yes
OP# 01164669Yes
OP# 01164669Yes
OP# 01139295No
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
OP# 01139295Yes
  • camargos88's avatar
    camargos88
    6 years ago

    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

1 Reply

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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