By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-dates-calculated-columns/

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 the basics of working with dates in calculated columns. You'll learn what the Auto Date Time feature in Power BI does. You'll see how to use functions such as Year, Quarter, Month and Day to extract parts of dates and how to use the Format function to return month and day names. You'll learn how to write literal dates in your expressions and how to calculate a date from its constituent parts using the Date function. You'll see how to calculate future and past dates using DateAdd and why that dosn't always work, as well as how to get around the problem using basic arithmetic. FInally, you'll learn how to calculate the difference between dates using the DateDiff function.

Chapters
00:00 Topic list
00:55 The Auto Date Time Setting
02:51 Working with the Automatic Date Hierarchy
05:46 Dates without Auto Date Time
08:03 Calculating Parts of Dates
10:44 Creating a Date Hierarchy
11:58 Hiding Extra Columns from the Report View
13:00 Adding Text to the Quarter Number
13:49 Changing the Sorting of Months
14:55 Calculating the Weekday
17:39 Using Dates in Comparisons
19:40 Using the Date Function
20:27 Calculating Future Dates
23:29 Calculating the Difference between Dates
24:29 Calculating the Current Date
25:25 Using the DateDiff Function
26:25 Calculating Age in Years

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!