Forum Discussion
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 co...
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.
lbendlin
Super User
Super UserOften 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.