find last date refresh by name of items

[MagMag31]

Hello,

i need yout help please
I have a table that contains several refresh dates and I need to display the last item by the last start date and the end date which corresponds to it

example :

result i want

thank you for you help

[FreemanZ · Accepted solution]

hi @MagMag31 

try like:

1) create a calculated table like:

Table = 
ADDCOLUMNS(
    DISTINCT(data[item]),
    "start refresh date",
    CALCULATE(MAX(data[start refresh date]))
)

2) join the new table with the data table on [start fresh date] column

3) add two calculated columns like:

end refresh date = RELATED(data[end refresh date])

Duration = RELATED(data[duration])

 it worked like:

[MagMag31]

it works thank you so much !