You searched for DAX - Excelerator BI

Search Results for: DAX

Part 2 – Filtering Out BLANKS in a MEDIANX Measure Using DAX Studio

This article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no […]

Read More »

Extracting Insights With Dax Logo

Extracting Data Insights with Power BI and DAX

Extracting Data Insights with Power BI and DAX training course is developed and delivered by Matt Allington, MVP (Power BI) and author of the best selling book Supercharge Power BI.

In this training, you will learn

  • What data modelling is all about.
  • Basics of DAX (Data Analysis eXpressions), the data modelling language of Power BI.
  • Use cases for common functions in the DAX language
  • The CALCULATE function that is the most important function in DAX
  • Table functions such as ALL and FILTER
  • Inbuilt Time Intelligence
  • What-if Analysis
  • The SWITCH function

The course includes several demos and hands on practice.

Extracting Insights With Dax Logo

Extracting Data Insights with Power BI and DAX

Extracting Data Insights with Power BI and DAX Video on Demand training course was developed by Matt Allington who is a Microsoft MVP(Power BI) and author of the best selling book Supercharge Power BI.  This training course makes complicated DAX concepts easy to understand. In this VOD training, you will learn how […]

Read More »

Introduction to DAX

In this lesson, you will learn how to write DAX formulas to create measures in Power BI. You will understand measures and calculated columns and when to use what.

Sydney Advanced DAX Training Sign Up

Demystifying DAX is a 1 day Intermediate to Advanced DAX Training course developed and delivered by Matt Allington who is a Microsoft MVP (Power BI) & author of the best selling book “Supercharge Power BI”.   This advanced DAX training course is ideal for people who already have a base understanding of DAX and […]

Read More »

Demystifying DAX – Live Advanced DAX Training

Best in Class DAX Training by Power BI Expert Matt Allington Face to Face live training is currently not practicable given the current troubles around the world with Coronavirus.  The good news is that Excelerator BI has now converted this live Intermediate-Advanced DAX Training course and turned it into a […]

Read More »

Large Customer Sales

The FILTER Function in DAX Part 2

Level: Intermediate In my last article, I introduced the basics of the DAX FILTER() function. Hopefully that introductory explanation to FILTER() helped you get your head around what FILTER() is doing under the hood. With that knowledge in place, let me help you take your understanding to the next level. […]

Read More »

Simple Filters and Syntax Sugar in DAX

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use the DAX language.  Here are a couple of examples Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount]) […]

Read More »

Time Intelligence Using DAX

Level: Intermediate Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence.  This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). This article is a follow […]

Read More »

Scroll to Top