New coloumn from data of other rows

[MG123]

I am looking for help on the following problem:

In my table visual I want to add a new coloumn which displays the Date of the ID Predecessor. For example, in the rows with ID 487, the ID's 485 and 486 are preceding in each row I want the new coloumn to display the corresponding Date.

486    INF 1.3     14.02.2020     484       31.01.2020

487    INF 1.4     28.02.2020     485       14.02.2020

487    INF 1.4     28.02.2020     486       14.02.2020

488    INF 1.5     06.03.2020     487       28.02.2020

 

[isabella · Accepted solution]

Hi @MG123 

You can create a column like this ：

Column = CALCULATE(MAX('Table (3)'[DATE]),FILTER('Table (3)', 'Table (3)'[ID] = EARLIER('Table (3)'[ID PREDESESSOR] )))

Best Regards,

Community Support Team _Isabella

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

[Anonymous]

Hi

This should works

var previd=selectedvalue(Table[ID])-1

var result=calculate(max(Table([Date]),Table([ID])=previd)