Forum Discussion
Merge or Join Two Tables On Matching Dimensions
Hi, This is a very common question/issue that I'm sure has many posts but I always struggle with following those because no example provided seems to be exactly alike what I am looking for. I am ...
Thanks. I believe your suggest has gotten me closer, however the final appended table that I'm getting isn't showing accurate total values. Also, In your example you have relationships between metrics (visits) from the parent tables to the appended table - this doens't work for me and gives me a error saying that one must have unique values. Considering they are metric/measure values, this column will always have duplicates.
Ultimately, I need to be able to have a sum value of visits from both tables in the appended table, at daily granularity.
Could you paste some data in copiable format with expected results?
I will try to get you the desired result in a pbix file