Forum Discussion

melodypoh's avatar
melodypoh
Frequent Visitor
8 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Connect them both to a shared calendar table that contains all dates for both years, then compare Augusts from there.

  • melodypoh's avatar
    melodypoh
    Frequent Visitor
    8 years ago

    Hi there, thanks for your help. I am gonna have to look into how to create a shared calendar table.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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

      • melodypoh's avatar
        melodypoh
        Frequent Visitor
        8 years ago

        Hi Angela,

         

        I am new to Power BI. Once I create a shared calendar table, how do I merge the two database together?