Tag: DAX Calculations

Power BI DAX Measures For Events In Progress

In this tutorial, I’m going to show you how to create Power BI DAX measures for events in progress. These events could come in the form of orders in progress or sales in progress, depending on the nature of your report. Basically, the challenge here is calculating results when there is more than one date

Continue reading

New DAX Function COLUMNSTATISTICS – Overview

This tutorial will walk you through COLUMNSTATISTICS() – a new DAX function, which is almost entirely undocumented. It has been added to Power BI in August 2021. You can watch the full video of this tutorial at the bottom of this blog. This function can be used to quickly create metadata on every table in

Continue reading

Power BI Dax Variables Are Constant: What Does This Mean?

Power BI DAX Variables Are Constant

Whenever you’ve heard an explanation of how to use Power BI DAX variables, you may have heard the phrase, “variables are constants”. It seems simple, but there’s a fair amount of nuance and complexity in these words. In this blog, I’ll walk you through what this phrase means, and the implications for how your measures

Continue reading

Power BI Matrix | How To Fix Matrix Totals In Power BI

Power BI Matrix | How To Fix Matrix Totals In Power BI

For this tutorial, I’m going to show you how to fix Power BI matrix totals, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. You may watch the full video of this tutorial at the bottom of this blog. There are two reasons why I wanted to address

Continue reading

DAX Query Optimization Techniques And Lessons

DAX Query Optimization Techniques And Lessons

This tutorial will discuss about DAX query optimization practices. You’ll learn what VertiPaq can do with caches to improve DAX performance and generate accurate results. VertiPaq Caches In DAX Calculations The first topic is the VertiPaq Cache. Before you run your queries, you have to clear the cache first because other users may not use

Continue reading