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

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!
  - SergeiBaklan
    Diamond Contributor
    Oct 14, 2023
    Excellove15
    
    I tried, done