Forum Discussion

Huggibear's avatar
Huggibear
New Member
3 years ago
Solved

Joins between dates

Hi I am new to Power BI. I am trying to Join a recently created Date Table (Calendar table) back to my main excel sheets. I have joint on date. However, it appears that the 2 datasets are still not connected as when I try combine data from the 2 tables I only get blanks. I will post some screen shots and the sample data shortly
  • lbendlin's avatar
    lbendlin
    3 years ago

    Often issues like this are caused by column type mismatch. For example your calendar date is of type "date" but your Excel date may be of type "datetime".  Ideally the types should match.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Often issues like this are caused by column type mismatch. For example your calendar date is of type "date" but your Excel date may be of type "datetime".  Ideally the types should match.