Power BI

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

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

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

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…

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…

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…