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!

This video shows you how to create a calendar table using DAX which includes a financial year, quarter and month column. You'll see how to calculate thes values using the AddColumns and Calendar tables, as well as how to use the calendar in measures with some of DAX's time intelligence functions.

Chapters
00:00 Topic list
00:49 The Data Model
02:17 The CalendarAuto Function
04:38 The Calendar Function
06:26 Using a Variable for the Start Month
08:39 Calculating the Start and End Year
12:59 Calculating Date Parts
14:55 Calculating the Financial Year
18:32 Calculating the Financial Month
20:52 Calculating the Financial Quarter
22:14 Using the Financial Year Calendar
25:36 Calculating Year to Date over Financial Years
27:12 The PreviousYear Function
28:48 DatesBetween, StartOfYear and EndOfYear Functions
30:21 Calculating the Percentage of Year Total

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!