Power BI

Scenario: We usually hear words like words context, filter context when creating measure. Moreover, we can often see it on the DAX Guide website. But what is that? And how can we modify it? What is filter context? The reason why we sometimes cannot get the ideal result when we use a measure with sa...

In this article, we will discuss how to deal with some common problems when creating reports based on employee attendance sheets. Next, let's take a closer look at the below scenarios. Scenario 1: Clean and extract valid records from attendance sheets Invalid or repeated employee punching behavior ...

I had a business requirement where I needed to create a P&L report that included RLS by business leaders for each department. A leader…

It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. In one of the last classr

In the 2nd part of "Brain & Muscles" behind Power BI series, learn about data compression and how VertiPaq chooses the right algorithm to make your data model optimal

Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? In the 1st part of the series, meet VertiPaq - "brain & muscles" behind Power BI!

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