Forum Discussion
index value based on max date across different tables
HI, I am very new to powerbi. Wonder if i could get some help wiht this. I have a merged and de-duped table of unique records with unique record Id's field popluated from few different source tab...
Ashish_Mathur
Super User
Super UserHi,
Share a dataset and show the expected result.
HI Ashish,
Here are my source tables examples and what I would like my merged table of Record ID's to look like.
Conference, exhibition and website sit as separate tables on powerbi.
My logic is the find the record id and look across the date filed in my source table, find the latest date and index the job title and latest date in corresponding fileds (and source if that is possible)
Thank you
| Merged list | ||
| Record ID | Job title | Date |
| 11 | Test1 | 01/01/2018 |
| 12 | Test 22 | 02/02/2018 |
| 13 | Test 333 | 01/01/2018 |
| 14 | Test 44 | 03/02/2018 |
| 15 | Test 5 | 01/01/2018 |
| 16 | Test 666 | 04/02/2018 |
| 17 | Test 77 | 05/02/2018 |
| 18 | Test 88 | 01/02/2018 |
| 19 | Test 19 | 01/01/2018 |
| 20 | Test 20 | 01/01/2018 |
| Conferece | Exhibition | Website | |||||||||
| Record ID | Job title | Date | Record ID | Job title | Date | Record ID | Job title | Date | |||
| 12 | Test 2 | 01/01/2018 | 11 | Test 1 | 01/01/2018 | 16 | Test 666 | 04/02/2018 | |||
| 12 | Test 22 | 02/02/2018 | 12 | Test 2 | 01/01/2018 | 17 | Test 77 | 01/01/2018 | |||
| 13 | Test 23 | 30/01/2018 | 13 | Test 333 | 01/01/2018 | 17 | Test 77 | 02/02/2018 | |||
| 14 | Test4 | 01/01/2018 | 14 | Test 44 | 03/02/2018 | 19 | Test 19 | 01/01/2018 | |||
| 16 | Test 66 | 01/02/2018 | 15 | Test 5 | 01/01/2018 | 20 | Test 20 | 01/01/2018 | |||
| 16 | Test 6 | 01/01/2018 | 17 | Test 77 | 05/02/2018 | 18 | Test 88 | 01/02/2018 |
- Ashish_Mathur