Power Bi Merge - Get Last Match Instead

[Rochejf]

Hi all,

I've been scrolling through this forum and I got a very good post regarding merging queries and obtaining the first match instead of using index numbers. 

What if I wanna obtain the last match instead? I will not be able to use the numbering filtering function anymore. So any help on this?

Example:

Table 1

ID	Date
A	01-01-23
A	02-01-23
B	01-01-23
B	02-01-23
B	03-01-23
C	01-01-23
C	02-01-23

Table 2

ID	Job Detail
A	Drilling
B	Milling
C	Extracting

Merge Table 1 to 2

ID	Job Detail	Date
A	Drilling	02-01-23
B	Milling	03-01-23
C	Extracting	02-01-23

[ryan_mayu · Accepted solution]

@Rochejf 

after merge the table ,you can group by 

pls see the attachment below