dax

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…

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

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

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

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

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.

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…

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

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.

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

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 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 shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Power BI offers the Au

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!

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

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

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?…

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…

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

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

When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this…

The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that

Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time windo…

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as y…

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. In this example, using CONCATENATEX helps iden

Video by: Reid Havens Learn how to implement some advanced DAX measure organization and sorting within Power BI. Including creating nested folders and putting one measure in two different folders .

This article explores the properties of calculation groups in detail and then it describes how a calculation item is applied to a measure. Before starting,