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 […]
Search Results for: 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.
I was going to title this blog “MEDIANX and the X Functions”, but that sounded too much like a 2030s band, so I opted for MEDIANX returns blank in DAX. But the article does indeed cover more than just MEDIANX and the blank “problem”. But first some background. I helped […]
I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to […]
I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc. As is often the case, I thought it would be a great blog article that I […]
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 […]
There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the image below – do you see it? Note the “new” function buttons? When I say […]
OK, by now you will likely be getting to understand that I think Tabular Editor is pretty cool. I like every bit about it, and I am learning more every day. Daniel Otykier has done a great job with this wonderful bit of software, and the more I use it […]
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.
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 […]
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 […]
Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as a table filter parameter inside CALCULATE() as shown in the following example. Total Sales All […]
On 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live training. But everyone is on their own learning journey and there are many people just […]
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. […]
Level: Intermediate FILTER() is one of the most important functions in the DAX language. It is quite a simple function and yet many people are scared off when they see it. In this article I will explain the basics of using the FILTER() function. Make sure you then read the […]
Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Reid Havens a couple of months ago. I blogged about various other ways of doing […]
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]) […]
I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits. Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris Webb and The Italians, but […]
Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as […]
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 […]