By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-basic-calendar/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Learn how to replace the auto date-time calendars in Power BI with a custom calendar using the CalendarAuto and Calendar DAX functions.

Chapters
00:00 Topic List
00:54 Disabling the Auto Date Time Feature
04:04 Custom Calendar Rules
05:31 The CalendarAuto and Calendar Functions
08:33 Using Variables for the Start and End Dates
10:56 Adding New Columns to the Table
13:19 Years, Quarters, Months and Days
15:51 Month and Weekday Names
17:02 Concatenating Labels
17:44 Combining Intervals in a Single Label
19:29 Marking a Table as a Date Table
20:32 Disabling Aggregation for Number Fields
21:23 Assigning Sort By Columns
22:34 Hiding Columns from the Report View
23:27 Displaying the Calendar in a Visual
24:32 Creating a Relationship to the Calendar Table
25:41 Creating a Hierarchy
27:24 Time Intelligence with Custom Calendars

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!