Category: DAX

Power BI Formula Syntax, Comments, And Variables

Today, we are diving into what you could do in the Power BI formula bar in terms of syntax, comments, and variables. These are all very important techniques that you could use in your work patterns. But before we jump into Power BI formulas, I’ll show you how I sort my Dates column within my

Continue reading

Simple Aggregations In Power BI

In this blog post, I’ll touch on some simple aggregations in Power BI that you can use in your DAX calculations. This is a continuation of the blog that I previously published, where I covered the differences between a measure and a calculated column. I’ll first continue working on the measures that I’ve gone through

Continue reading

Time Intelligence DAX Functions In Power BI

For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX

Continue reading

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside

Continue reading

DAX Measures In Power BI Using Measure Branching

Build DAX measures using measures. This is what I call measure branching. This technique is one of the most important development strategies that you need to learn. Measure branching in Power BI is about creating advanced measures within a measure itself. I always recommend that you start with simple DAX measures first so you can

Continue reading