Forum Discussion

scign's avatar
scign
Frequent Visitor
8 years ago

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.   Table RecordID ...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

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? :smileyhappy:

 

Regards

scign's avatar
scign
Frequent Visitor
8 years ago

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