DAX

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation i…

This blog post shows you how to use the DAX function EvaluateAndLog and how to use the DaxDebugOutput app with Power BI to view the results

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September. ✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex

Time to read: 5 minutes Have you ever wanted to search through your Power BI measures, calculated columns or calculated tables for a specific function or table/column reference? Or export your DAX logic for documentation purposes? If this is the case then this post is for you. As a Power BI dataset admin or author, ... Read more

Over the past few days, I attended the Power BI Next Step conference in Lego land – Denmark. During the keynote, Will Thompson – PM on the Power BI team, showed a new DAX function that …

Last week, we learned how to interpret the output of the EvaluateAndLog function of scalar expressions. Albeit interesting, the new function would be much less useful if it could only return scalar…

The Switch function is often a cause of performance problems in DAX. Last year a number of optimisations were made that fixed the most common issues (and as a result you should ignore older blog po…

Field parameters are great for dynamic legends, but the creation of a dyanmic measure + time intel chart can be time consuming. Most of it can be automated.

This is the fourth and the last article on the EvaluateAndLog function. While DAX developers were excited about the prospect of printing the values of a portion of a DAX expression, many of the ear…

With conditional formatting and a few calculation groups it's possible building a fading bar chart, even assigning colors to categories by code.

The task of creating calculation groups to active calculation groups can be automated with a C# Script. This script contains custom classes.

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

DAX Studio 3 has been released today. This new major version has a new user interface and user experience, providing a modern look and feel without losing a

Contribute to samaguire/TabularEditor3Scripts development by creating an account on GitHub.

This is the second article in a series on the introduction to the EvaluateAndLog function. As I explained last time, EvaluateAndLog can be used to print to the debug output the intermediate result …

Since the start of the COVID-19 crisis, we are bombarded daily with graphics depicting exponential and rolling trends. These analyses are a powerful way to reveal trends in variable, incomplete and discrete data; however, interpreting them is more difficult.

We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filt

Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why

This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected m

In a previous article about Field parameters, I spoke about using them in cooperation with Calculation groups (LINK). I used them to get specific measures for selected dimensions from the dimensions field.

There is a hidden gem in the August 2022 release of Power BI Desktop: a secret new DAX function EvaluateAndLog that is not listed in the feature summary of the official blogpost. Yet this function …

Another reason why using a measure table in a Power BI model is a good idea

Controlling Calculation Items with RLS can't be done directly, but you can do it indirectly with another calculation group. This article shows you how.

Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the w

This article shows how to compute a rolling average (useful to smooth out charts) taking into account only the working days.

Use products table to find missing values in the fact table. Find Missing Products that did not sell.

Conditional formatting is an easy way to highlight values so report users can receive quick insights on the status of key metrics. In this post, I will be showing a way to apply dynamic conditional formatting on visuals with set thresholds. This will...

Power BI is full of hidden gems! This one can literally make you a real Power BI hero out of nowhere!

The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. The SWITCH function in DAX is widely used to define different execution paths depending on the condition of an expression. A very common case is when we want to check the sta