Forum Discussion

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

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

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
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
  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?
  - v-huizhn-msft
    Microsoft Employee
    8 years ago
    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

Forum Discussion

Create relationship without unique IDs

Related content

Creating relationships

Relationship

Create relationship dialog box

Relationships

Relationship Issue