Display Data in visual Table with duplicate conditions

[Anonymous]

Hi, 

I am trying to visualise data in in the visual table in Power BI.

Here is the data exported into Excel 

End Time column is from another table which is linked the work orders table which supply the first three columns. Adding the last column causes the first few columns to duplicate. 

I am wondering if it possible through DAX or any other means if I could show the work orders by the lastest End Time in the table

like this for example so

To show the latest bookings for each work order ID

Thanks for the responses

[VasTg]

@Anonymous 

Do you have relationship defined between the tables? If so, by which colum?

Did you try Max(End Time)?

If it helps, mark it as a solutuion

Kudos are nice too

[Anonymous]

Hi,

Yes there is 1 to many link 

between the workorder table and the table showing the end date. 

[VasTg · Accepted solution]

@Anonymous 

Did you try Max(End_Date)?

[Anonymous]

Tried measure Max(End Date) on the table with the end date column and it worked. When inserted it into the visual.

Thank you