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/freeex...
Link to SQLBI Article on Mark as Date Table
https://www.sqlbi.com/articles/marka...
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
/ wynhopkins
Twitter
/ wynhopkins
Access Analytic Training
https://accessanalytic.com.au/training