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 ID Opty repeat OP# 01139295 No O...
  • 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

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