cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
scign
Frequent Visitor

Dynamic join based on field contents

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.

 

TableRecordIDDateTimeUser
Case164334/10/2017 11:39User1
CaseMember882634/10/2017 11:41User1
Action72324/10/2017 13:41User2
CaseMember882634/10/2017 13:51User2
CaseMember298644/10/2017 14:14User2
Case164334/10/2017 15:57User3
CaseMember963854/10/2017 15:59User3
ProgressNote1321364/10/2017 16:00User3
ProgressNote1321374/10/2017 16:05User3
Case164334/10/2017 19:22User2
ProgressNote1321364/10/2017 19:25User2
CaseMember963864/10/2017 19:29User2

 

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?

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

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? Smiley Happy

 

Regards

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...

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.