Forum Discussion

Excellove15's avatar
Excellove15
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: ...
BI & Data Analysis
developer
excel
Excel for web
Excel on Mac
Excel on mobile
Formulas and Functions
Macros and VBA
office 365
power bi
  • SergeiBaklan's avatar
    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's avatar
    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's avatar
      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's avatar
        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?

Resources