Combining data between 2 unrelated tables

[Jo5hua22]

Hello community,

I would require your help in using data from a table that is unrelated to another table.

When i try to use the data in the visuals, I am getting error as they are unrelated.

Example:

Sales Table:

Claim Table:

I would like to use line & stacked column chart where the column value should contain the data of number of claims in a year/month. The x axis should be claims date. The line value should contain the total sales for the year/month (month view through drill down feature)

Example of Expected visual:

Can you please help me out in this?

[Jo5hua22]

Hi
Yes! The answer is

Step 1: create a new date table for the years(2020 to 2030?) you want.

Step 2: Link the dates of the unreleated tables with the common date table (Table A <-> Date Table; Date Table <-> Table B)

[mh2587]

Try to full outer join on Surogate Key , Make two index column in both the table then relate it for further detail follow the link    https://community.powerbi.com/t5/Desktop/Merging-two-unrelated-tables/m-p/22543#M7096

[amitchandak · Accepted solution]

@Jo5hua22 , create a common date table and join it with the sales date of the first table and the claim date of the second table.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Jo5hua22]

Hi 

Thanks for the idea. But it is not working. I am still facing the same error. I created a new date table and linked sales and claim date with it. But when I do it, the date hiearchy option is removed and I am not able to get the needed visual

[Reine]

Hi - did you ever figure this out?  I'm facing the same issue right now 😞