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.   ...
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.

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 😞