Power BI

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

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

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

Using this feature effectively can have the biggest impact on your organizations use of data and exponentially increase to value you generate.

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

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

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

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.

Data Validation with Power BI is not impossible but messy. Here a script and a couple of calculation groups are used to streamline the process.

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

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 …

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.

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

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

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

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 …

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

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

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

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

Defining different formats for values and totals in Power BI can be achieved with the use of a calculation group which will reuse the original format string.

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

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…

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.

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…

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…

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 …

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

✨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

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