Forum Discussion
Create relationship without unique IDs
Hi, I am trying to compare sales from August 2017 (file 1) to August 2015 and 2016 (file 2). I can't connect them because there are duplicated SKUs sold all the time. How would you guys may go about ...
Hi Ashish, How do you build a relationship using the date column? They are all different dates right? It's been a long time since I touched SQL. I feel like I am starting over again.
Hi,
Once you have a date column in each dataset, you have to go to Modelling > Manage relationship and create a relationship from the date column of each dataset to the date column of the calendar table. Please read up on how to create a relationship in Power BI desktop/PowerPivot.