Topic: DAX

       Page 3 of 39 videos
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

video –

DAX Time Intelligence

Alberto begins this video with a brief introduction to Time Intelligence, before showing you how to create a calendar table, which is needed for any time intelligence function to work. It can be created using Excel, or by loading it…  Watch now

video –

Querying in DAX

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