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

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 13, 2023
    Hi SergeiBaklan
    
    Welcome Sir!
    I have raised a query regarding creating of visual using Dax measure in separate query. Link below:
    Relationship issue when Calendar table filtering two date columns in fact table - Microsoft Community Hub
    
    It would be great, if you can guide me on this!
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!