by Nikolai Pavlov | Jan 25, 2021 | Video
When using CALCULATE in DAX, you need to always make sure that correct filters are applied. In other words, CALCULATE you can override the existing filter context with the new ones inside the function. Watch our short tutorial above. Basic calculation: First, let’s...
by Nikolai Pavlov | Jan 7, 2021 | Video
In this video, we discuss how to perform a scenario analysis in Power BI using DAX. This is the second part of the tutorial. We’ll build the measures to calculate a percentage change in total sales when certain sales channels are selected. The example shows how...
by Nikolai Pavlov | Dec 27, 2020 | Video
In this video, we discuss how to perform a scenario analysis using DAX in Power BI. In the first part of the tutorial, we analyze how a price change affects total sales. To do this, we’ll build a supporting table with different price values, connect the table to...
by Nikolai Pavlov | Dec 17, 2020 | Video
In this video, you’ll see a few examples of using SUMIF and COUNTIF in Power BI. When Excel users come to Power BI, one of their first questions is “How do I use SUMIF?” Turns out, there are no SUMIF and COUNTIF functions in Power BI. However, with...
by Nikolai Pavlov | Dec 5, 2020 | Video
In this video, we’ll take a look at the SWITCH function in DAX. The SWITCH function in DAX compares a declared expression against all values. If the expression matches the value then it returns the result, if it doesn’t, it keeps moving down the list until the value...
