How to use FILTER in DAX the correct way
The FILTER() function in DAX can be challenging to tame. Here are some examples on how to use it and how not.- 28198Murphy ≡ DeepGuide
A better way to get results without data
Imagine having a data set and wanting to see zeroes instead of empty cells. Sounds easy? Well, this case has some caveats.- 28164Murphy ≡ DeepGuide
On using intermediary results in DAX Measures
We use table variables in DAX all the time. What if we must calculate intermediary results and reuse them in a DAX Measure? Let's solve...- 28281Murphy ≡ DeepGuide
Analyze performance when aggregating data in Power BI and DAX Queries
We aggregate data in Power BI all the time. Here I show you how to write queries in DAX to summarize columns to aggregate data- 26665Murphy ≡ DeepGuide
Change your focus over time in DAX Measures
How to determine if your investment has paid off when you advertise products over time- 29855Murphy ≡ DeepGuide
Develop and test RLS Rules in Power BI
Very often, not all Users should have permission to access all data in a Report. Here I will explain how to develop RLS Rules in Power BI- 23280Murphy ≡ DeepGuide
Uncovering the secrets of KEEPFILTERS in DAX
The KEEPFILTERS() function in DAX is an underestimated function. Let's go into the rabbit hole of this function and discover some secrets- 22747Murphy ≡ DeepGuide
Changing perspective on your data in Power BI
Introduction Imagine a Report page with some Cards, columns, and line charts. On top of the page, you will see four buttons: Actuals YTD (Year-To-Date) YE (Year-End) Last three months Something like this: When you click on the Button YTD, your numbers wil- 29897Murphy ≡ DeepGuide
Combining Actuals and Forecasts in one continuous Line in Power BI
In several businesses, we have the Actual Sales and Forecasts. How can we show both datasets on one line?- 22230Murphy ≡ DeepGuide
Explore variants of Time Intelligence in DAX
We have some valuable functions to calculate the previous year, YTC, etc., in DAX. But other functions allow us to calculate the same result differently. Let’s explore our options and why they matter. Introduction When we look at the values in a rep- 22140Murphy ≡ DeepGuide
Going the Next Step with Stock Measures in DAX
Introduction Stock calculations are commonly used when data cannot be aggregated over time. For example, summing up my bank account balance over time would be a bad idea. It would be a good idea for me, but not my bank. Currently, I am working on a client- 27530Murphy ≡ DeepGuide
About Calculating Sales depending on another Value in DAX
Measures aggregate the Values from columns in one Fact table. But what if we need a dependency to another table?- 28748Murphy ≡ DeepGuide
On Handling Precalculated Hierarchical Data in Power BI
While hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Let's see a not-so-unusual case.- 29614Murphy ≡ DeepGuide
How to Manipulate the Total in Power BI
In most cases, the total aggregates the detail rows in a visual. But what if the Total should show something different?- 24004Murphy ≡ DeepGuide
How to Calculate a Moving Average Over Multiple Periods in DAX
Calculating a moving Aggregation is easy in DAX. However, there are some pitfalls when calculating the moving average. Let's look into it.- 26796Murphy ≡ DeepGuide
While Using RLS When Manipulating Relationships in Power BI, What Can Go Wrong?
There are restrictions when manipulating Relationships with RLS in place. The MS documentation doesn't provide details so let's look at it.- 22598Murphy ≡ DeepGuide
Calculating a linear extrapolation (or Trend) in DAX
In DAX there is no built-in method to calculate a Trend. Therefore we must do it manually. Let's look at how to do it.- 27978Murphy ≡ DeepGuide
How to do Date calculations in DAX
Moving back and forth in time is a common task for Time Intelligence in DAX. Let's take a deeper look on how DATEADD() works.- 22018Murphy ≡ DeepGuide
Advanced Time Intelligence in DAX with Performance in Mind
We all know the usual Time Intelligence function based on years, quarters, months, and days. But sometimes, we need to perform more exotic timer intelligence calculations. But we should not forget to consider performance while programming the measures. I- 21648Murphy ≡ DeepGuide
How to Develop Complex DAX Expressions
On the importance of taking some time to thoroughly understand the needs and the possible future use cases for the requested measures- 24952Murphy ≡ DeepGuide
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag