Channel: WiseOwlTutorials

Category: Education

Tags: datefree tutorialyearweekdaydate timedtdatediffdatetimedatetimestodaymonth namedaxtutorialdate diffdayday of weekutctodaycalendardate literalutconline trainingpower bidatesfree trainingdate addexpressionsday nameonline tutorialcalculated columnmonthdateaddwise owlquarter

Description: By Andrew Gould Download files here 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 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!