cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Microsoft
Microsoft

Re: Dynamic join based on field contents

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

Highlighted
Frequent Visitor

Re: Dynamic join based on field contents

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
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors