dax

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

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

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…

Writing Tabular Editor C# Scripts in Visual Studio has many benefits, on top of all Intellisense. This article walks through the configuration process.

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via [...]Read More »

Analyze, visualize, and report on your data using 92 new DAX functions when creating measures in Power Pivot.

In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet documented on https://learn.microsoft.com/en-us/dax/ as of today. When I face the situation to measure date-intelligence-related business requirement, I use SAMEPERIODLASTYEAR, DATESINPERIOD, DATEADD, and so many other time intelligence DAX functions, if a business is using normal & general calendar table. Or, I use FILTER, MIN, MAX, and some other DAX functions, if