Forum Discussion
Solved
Create a relationship between two data tables via linked lookup tables
Hi, Bit of a beginner here, I am sure this is very straightforward. Many thanks to anyone who takes the time to help. I am trying to create a relationship between two data tables, Account Dat...
Hi,
Please find attached the PBI file.
Hope this helps.
Hi,
Please find attached the PBI file.
Hope this helps.
Brilliant! Thanks Ashish_Mathur
So I create a many-to-many relationship between Account Lookup and Benchmark Data and then I can use that relationship in my Benchmark Weight measure.
I'm not too sure on when it is good practice to use many-to-many relationships, I'll look into this.
Thanks again, Tim
You are welcome.