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 melodypoh,
There must be a min and max date in the three datasets. Please create a calendar table using the formula.
Calendar=CALENDAR([MinDate], [MaxDate])
Best Regards,
Angelia
Hi Angela,
I am new to Power BI. Once I create a shared calendar table, how do I merge the two database together?
Hi melodypoh,
You need to create a relationship between Calendar to file1(database1), another relationship between Calendar to file2(database2), how to create relationship, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-and-manage-relationships/.
Best Regards,Angelia