Forum Discussion
Jo5hua22
Helper I
Helper ICombining 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. ...
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.
Jo5hua22Helper I
Helper IHi
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)