Dynamic join based on field contents

[scign]

I have an audit log (not designed by me and unfortunately I can't change the design!) which identifies a change made by recording the table name and the ID of the record e.g.

Table	RecordID	DateTime	User
Case	16433	4/10/2017 11:39	User1
CaseMember	88263	4/10/2017 11:41	User1
Action	7232	4/10/2017 13:41	User2
CaseMember	88263	4/10/2017 13:51	User2
CaseMember	29864	4/10/2017 14:14	User2
Case	16433	4/10/2017 15:57	User3
CaseMember	96385	4/10/2017 15:59	User3
ProgressNote	132136	4/10/2017 16:00	User3
ProgressNote	132137	4/10/2017 16:05	User3
Case	16433	4/10/2017 19:22	User2
ProgressNote	132136	4/10/2017 19:25	User2
CaseMember	96386	4/10/2017 19:29	User2

I want to be able to bring up the whole record that was modified. Is there a way I can dynamically link to the related information based on the value of the "Table" field as well as the record ID? My first thought was that this is similar to the "INDIRECT" function in Excel but not sure how to replicate that in Power BI. Thoughts?

[v-ljerr-msft]

Hi @scign,

---

I want to be able to bring up the whole record that was modified. Is there a way I can dynamically link to the related information based on the value of the "Table" field as well as the record ID? My first thought was that this is similar to the "INDIRECT" function in Excel but not sure how to replicate that in Power BI. Thoughts?

---

I'm not sure I can understand your requirement totally. Could you post the expected result again your sample data, so that we can better assist on this issue? 

Regards

[scign]

I realize that my description was not an accurate description of what I want to achieve.

I have filters set up on various tables, including cases and case members, and I only want to see log entries that relate to the filtered list of cases.

Perhaps a solution would be to create new tables dynamically and create the cross-filter relationships but I'm not quite sure how to do that...