Correct Way to Fill out Date

Hi everyone,

I was wondering what is the correct way to populate the date format for Excel in order for PowerBI to make a good relationship from Calendar table to the Date of the Excel Worksheet. Below is how I make my date table in Excel,

Whenever, I connected with multiple _facttables, [Above the image is one of them], wont work properly if I connect to the Calendar table, 

Any recommendation to improve my experience using PowerBI, I would greatly to open to hear. Thank you!