Forum Discussion

pagliaci's avatar
pagliaci
Frequent Visitor
4 years ago
Solved

Reference a row in another column

Hello, I hve two columns in the same table, onde of them is the index one, I want to reference the id number of that index, for example:   ID                         INDEX 8027890                 ...
index
reference
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, pagliaci 

    According to your description, I can clearly understand your requirement, you can try to create a calculated column like this:

    Column =

var _lastID=CALCULATE(MAX('Table'[ID]),FILTER(ALL('Table'),[INDEX]=EARLIER('Table'[INDEX])-1))

return

IF([ID]=_lastID,"SAME ID","DIFFERENT ID")

     

    And you can get what you want, like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, pagliaci 

According to your description, I can clearly understand your requirement, you can try to create a calculated column like this:

Column =

var _lastID=CALCULATE(MAX('Table'[ID]),FILTER(ALL('Table'),[INDEX]=EARLIER('Table'[INDEX])-1))

return

IF([ID]=_lastID,"SAME ID","DIFFERENT ID")

 

And you can get what you want, like this:

 

You can download my test pbix file below

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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