Project Botticelli

Introduction to DAX Get Free Access Purchase this course

23 November 2017 · 1391 views

Mastering DAX Workshop

This 1-hour, free video introduces you to the language of DAX: Data Analysis Expressions. Watch it to get a feel for the power of this language, and to see it in action, in many of the detailed, live demos that this workshop offers. Log-in or get a free account to watch it! Learn from the undisputed masters of DAX: Alberto Ferrari and Marco Russo.

Starting with the syntax and the data types, you will see the difference between a calculated column and a measure (also called Calculated Field, in Excel terminology). It is important to follow the naming conventions and and to understand when to use measures rather than
calculated columns.

You will also discover the most commonly used functions in DAX for error handling, aggregating numbers and for countng values.
Other functions covered are logical functions, SWITCH, information functions, MIN and MAX, mathematical functions,
DIVIDE.

You will also learn the syntax of variables, which have been introduced in DAX for Power BI Desktop, Excel 2016, and Analysis Services 2016.
Finally, you will quickly review rounding, text, and date functions and relational functions.

At the end of this module, you should practice with Lab 1.

Log in or register for free to access this content.

Purchase This Course or Full Access Subscription

Single Course

$350/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses