DAX

This article is the first of a series dedicated to calculation groups in DAX. This introduction explains the capabilities of this feature and how to create

This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the anal

A new update to DAX Studio is now available at https://daxstudio.org which includes the following: New Features Import Power BI Performance Data Support for Display Folders in the Metadata pane #127 A…

You have created a Power BI report with many visualizations and calculations, however, it is slow! And the slowest part of that is the report page with a matrix or table visual in it! Why that visual is so slow? Is this the problem of Visual in Power BI? or Power BI problem at all?…

The DAX Debugger measure shows details of the filter arguments from your CALCULATE measure if you have to debug it. M-function creates the code automaticall

[Blog] How to solve recursion problem in Power BI using Power Query: Provisional stock data example by @JoanaVBarbosa

Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a little DAX into Power BI Desktop to get this going!

This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Power BI offers the Au

This article shows how to build a basic date table using a calculated table and DAX. A date table is required for most time intelligence calculations such

This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code

I was looking at my blog stats and found that some of the most popular posts are almost 10 years old (yes really). Those topics are actually still relevant so...

This blog post explains how to use DAX to solve a Power BI measure requirement where the user wanted to calculate the difference between slicers

PowerBI SmartPivot is our first product for 2019, and we couldn’t be more excited about it. If you want to learn how to use all of its features, you've come to the right place.

Welcome back! Today we are going back to RANKX-apalooza! We are going to add two approaches that will allow you to apply RANKX across multiple columns. I went back and recreated the examples from the original post using the AdventureWorks Database as source material and have a zip with the examples in both a .xlsx

I’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic. Usin…

This error occurs whenever the DAX engine was expecting a single value, or scalar, and instead received a table of values instead. This is an easy error to make because many DAX functions, such as FILTER, SUMMARIZE and ALL, return table values.

Time intelligence functions oftentimes hide an automatic ALL statement meant to make time intelligence calculations easier. This article describes this beha

A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answe

Learn how to analyze categorical data in Excel with the use of Pivot tables [with video}

This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total v

The error is caused by using a TRUE/FALSE expression, something that evaluates to TRUE or FALSE, to filter the table in a way that CALCULATE or CALCULATETABLE doesn’t support. So the error is saying y…

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…

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply…

Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level. Original Quick Measure video Alberto’s article

This article shows a DAX technique to compute the number of working days between two dates. The example includes a Sales table containing order and deliver

Hello P3 Nation! After having the privilege of working with so many of you to share your journeys and techniques I was inspired to share my own. This is a bit of an intimidating group, and I struggled a bit with what to share. After much deliberation, I compromised with myself on a journey story. My journey does not

This Power BI blog post details how to easily edit long measures that are created in Power BI desktop and how to use the Data View