Topic: DAX

       Page 3 of 41 videos
video –

Advanced Modeling with Analysis Services Tabular

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You…  Watch now

video –

DAX Patterns

The DAX language has a low number of built-in functions, but it is very flexible and you can write complex calculations with it. It is so flexible that you might find many alternative ways to write an expression solving a…  Watch now

video –

DAX as a Query Language

DAX is not only an expression language, but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless,…  Watch now

video –

How to Calculate with Hierarchies in DAX?

Marco Russo discusses ratio-to-parent measures, which use DAX hierarchies, in this short video. You will see how to create such a calculation and how to use it in a Pivot Table (00:30). DAX does not have an internal mechanism for…  Watch now

video –

Hierarchies in DAX

Marco Russo shows you how to handle hierarchies in DAX in this 55-minute, demo-focused video. Although DAX does not have a specific syntax for working with categories, hierarchies can be defined in the data model in Power Pivot and in…  Watch now

video –

Many-to-many Relationships in DAX

Let Alberto Ferrari show you how to work with many-to-many relationships in DAX by using an example from a banking data model. Unfortunately, these types of relationship do not just work out-of-the-box—you need to apply correct DAX formulas to benefit…  Watch now

video –

DAX Patterns: Banding, New vs Old, Many-to-many

Alberto Ferrari shows how to solve common business patterns using the DAX language in this 50-minute, demo-focused video. Patterns are useful for two reasons: they let you learn advanced DAX techniques and, by adapting their code to your needs, you…  Watch now

video –

What is Time Intelligence?

ime Intelligence simply means doing BI calculations over periods of time, or over dates. For example, a common request in many reports is to show a value, such as Sales, aggregated month-by-month, from the beginning of each year—so that you…  Watch now