Forum Discussion

norocdinu's avatar
norocdinu
Frequent Visitor
3 years ago
Solved

Looping between 2 rows and create a 3rd row

Please help. I have a situation where I have two ID columns. first one is the Initial ID second is the new ID. Over time the new ID wil be moved in initial ID and be once again replaced with a new...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi norocdinu ,

    According to your description, It's easy to do in DAX with PATH function, create a calculated column.

    Column =
PATHITEM ( PATH ( 'Table'[ID], 'Table'[New ID] ), 1, TEXT )

    I shuffled the data order of the sample, get correct result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi norocdinu ,

According to your description, It's easy to do in DAX with PATH function, create a calculated column.

Column =
PATHITEM ( PATH ( 'Table'[ID], 'Table'[New ID] ), 1, TEXT )

I shuffled the data order of the sample, get correct result:

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • norocdinu's avatar
    norocdinu
    Frequent Visitor
    3 years ago

    Thank you! This worked perfectly!