What is a Date Table / Calendar table in Power BI / Excel

What is a Date Table / Calendar table and why do you need one Link to Free Download of our Power Query Calendar: https://accessanalytic.com.au/free-excel-stuff/free-excel-templates/ Link to SQLBI Article on Mark as Date Table https://www.sqlbi.com/articles/mark-as-date-table/ 02:28 Turn off Auto Date Hierarchy 03:52: Copying a Power Query Calendar between Power BI Files 05:20 Changing the Start Date and End Date 07:15 Sorting Months and Days to display correctly 09:47 Changing the Financial Year End, Day of Week and Advanced Editor features 11:28 How the Calendar was built 13:46 Marking Calendar as Date Table 15:46: SQBI link 16:20 Total YTD 18:20 Copying a Calendar table into Excel Follow me on LinkedIn https://www.linkedin.com/in/wynhopkins/ Twitter https://twitter.com/wynhopkins Access Analytic Training https://accessanalytic.com.au/training