Free SQL Server Training Webinars

We provide an array of sessions for those needing introduction, mid-level and even expert topics. Over 300 SQL Server data platform topics are covered including topics great for DBA’s and BI/Analytics professionals.   

Enhance your SQL Skills with Pragmatic Works 2 times a week.


Speaker Description
Dan Clark Dan Clark

Mastering Date-Time Based Analysis in DAX

Instructor: Dan Clark

Date/Time: 3/27/2012 11:00 AM

A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them.

This webinar is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them. We will also cover time intelligence best practices and how to avoid the many “gotchas” that can occur by misusing these functions.

Copyright 2014 by Pragmatic Works