dax

One of the powerful features of the Tabular data model is to extend the model by adding calculated columns and measures. Both objects are defined using DAX, but besides this similarity, they are entirely different beasts. Here you will find guidance when to use what!

CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it. CALCU

Reduce the number of measure you create by using Calculation Groups in Power BI. This blog will guide you through to get started.

Building a Dynamic KPI card with Calculation Groups allows to modify the base measure as well as the transformations to use for comparison.

In this post, we will take a step by step approach to simplify a report with 6 pages + 12 measures into 1 page report + 1 measure. After optimising the report, we will explore a change that will …

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it r

It's a terrible title, but by the end I hope it makes sense Today I had some spare time and I thought I would do some c# that is always good to keep your mind going.  The goal was to create a script that given a base measure, you can then specify a column and a new measure will be generated for e

Dynamics 365 CE, and Model Driven Power Apps built on Dataverse can create views to be filtered to only show records where a username field on that record, such as 'owner' equals the current user. (e.

Imagine you bought a brand new, top of the line red Ferrari, but in place of a performance driver's seat, it came with a $10 folding lawn chair installed... 26 comments on LinkedIn

In many businesses, sales don't come in equally distributed over the year. Learn how to deal with Forecasting with seasonality in Power BI.

To group some data in the report, it is very common to create a custom column or a calculated column based on specific conditions, and then put this column in a slicer to filter visuals. This would generate more data in the model and the group result is fixed. If the data used in the conditions is f...

Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather than be scared of it.

This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and i

I show how using different Power BI DAX queries gives you the same result, one DAX measure uses a lot of resources and the other uses almost nothing.

Continuing on my exploration of field parameters, in this post I want to share how you can use field parameters and modelling to dynamically sort columns in a table with a slicer and also switch ro…

In May 2022 Desktop update, we recieved the Field parameters function into Power BI. This function lets us change dimensions in visuals with a simple click on the slicer.

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

Using a script to create measures from a calculation group with correct format, for use cases where a base measure and a calculation group filter will not work.

When migrating processes you need to compare the outputs thoroughly. Power Query is a great tool to build such comparisons as you can refresh from the source.

Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals and total…

Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks!

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.