Forum Discussion

Iron Contributor

Oct 03, 2023

Solved

How to create a relationship between two tables using a common key

Hi, I have three dimenstion tables as below and merged these 3 tables into one: The merged dimension table looks like below: similarly I have a data table as below: ...

Formulas and Functions

Macros and VBA

office 365

power bi

SergeiBaklan
Oct 09, 2023
Excellove15

Thank you, I only downloaded it. Could you please clarify how you'd like the relationships to work. Not for each contact you have many point, for each point many Data records and for each many communication records. You'd like for each client to show all related communications records or what?

SergeiBaklan

Diamond Contributor

Oct 09, 2023

Excellove15

Unfortunately link doesn't work

Excellove15

Iron Contributor

Oct 09, 2023

Hi SergeiBaklan ,

Apologise, please let me know if this link below works for you:
https://1drv.ms/u/s!AhUFhM5jR1jqijLRCk1rWG1ZrviF?e=2G2R0T

please let me know if you are not still able to access

Thanks in advance

Excellove15
Iron Contributor
Oct 09, 2023
Hi SergeiBaklan

Just to confirm,are you able to access this file?
Any update on my query?

Thanks in advance
- SergeiBaklan
  Diamond Contributor
  Oct 09, 2023
  Excellove15
  
  Thank you, I only downloaded it. Could you please clarify how you'd like the relationships to work. Not for each contact you have many point, for each point many Data records and for each many communication records. You'd like for each client to show all related communications records or what?
  - Excellove15
    Iron Contributor
    Oct 13, 2023
    Hi SergeiBaklan ,
    
    Many thanks for your patience!
    I have resolved this query at my end & closed this query
    
    Thanks