Need help connecting Date table to Fact Table

Hi Anonymous 

What about inserting a new calendar table using the "calendar" function and then linking it with the date column in the 'Order Table'?  

The dax formula below will generate a calendar table based on the minimum and maximum date in your fact table.

If you needed year, month, quarter, columns added, you can use "addcolumns" at the beginning like shown in an example below.