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?

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
  - SergeiBaklan
    Diamond Contributor
    Oct 13, 2023
    Excellove15
    
    Great to know, thank you for the update
- Excellove15
  Iron Contributor
  Oct 09, 2023
  Hi SergeiBaklan,
  
  Many thanks for your prompt response sir!
  Is it fine if I get back to you tomorrow with more details?
  
  Thanks in advance!