Forum Discussion
Merge or Join Two Tables On Matching Dimensions
HI lemarcfj
Instead of a merge query.. do an append query
Then select the 2 columns "Creative Elements" and "campaigns Columns" in new append query and merge them using merge columns
Then select the merged column and select from the Home Tab>>>Keep Rows>>Keep Duplicates
See the attached file it will give you an idea how to do it
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