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 tables i.e conference attended, exibition attended, website registration etc,
A record can be present more than once in any of these tables and across these tables.
The source tables also include date and demographic fields.
I want to index the latest job title into my merged and de-duped table of record id's, looking at the max /latest date across these tables.
Is there a way of finding the max date from the date fields across these different source tables for each record id and then index the corresponding job title in my unique record id table.
Would be great to get some help on this.
3 Replies
- Ashish_Mathur
Super User
Hi,
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
