Forum Discussion
Solved
Power Bi Merge - Get Last Match Instead
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 |
