How to get a filterd table based of highest values and an other tabels column?

[dmilardo_au]

Hi, I have two tables.

Table 2 filters Table 1 in my modell in PowerBi. I want to get a new table which contains all rows of table 1 with the highest result_id filtered by different the rivet_point's which are in a column of table 2. There are many result_id's for each rivet_point. But I want only the last result_id for each rivet_point which means the highest result_id for every rivet_point.

I hope you can help me

Table 1:

Table 2:

[amitchandak]

@dmilardo_au , Assuming both are related based on rivet_point

a new table = filter( addcolumns( Table1,

"Col1" = maxx(filter(Table2, Table1[rivet_point] = table2[rivet_point]), Table2[result_id])  )

, Table2[result_id] = [Col1])

[dmilardo_au]

Thanks for your response @amitchandak.

I tried it but I get the warning that ADDCOLUMNS needs 3 arguments.