Forum Discussion

Jo5hua22's avatar
Jo5hua22
Icon for Helper I rankHelper I
5 years ago
Solved

Combining data between 2 unrelated tables

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?

data protection
  • amitchandak's avatar
    amitchandak
    5 years ago

    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.

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Jo5hua22
      Icon for Helper I rankHelper I
      5 years ago

      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's avatar
        Reine
        Icon for Helper IV rankHelper IV
        4 years ago

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

  • Jo5hua22's avatar
    Jo5hua22
    Icon for Helper I rankHelper I
    4 years ago

    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)