Select Page
VIDEO: scenario analysis (part 2)

VIDEO: scenario analysis (part 2)

In this video, we’ll continue to learn the price scenario analysis method using DAX. We’ll build the measures to calculate a percentage change in total sales when certain sales channels are selected. The example shows how the price increase in certain...
VIDEO: scenario analysis (part 2)

VIDEO: scenario analysis (part 1)

In this video, we’ll learn how to do a scenario analysis using DAX. 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 a new...
VIDEO: scenario analysis (part 2)

VIDEO: using SumIF and CountIF in Power BI

In this video, you’ll see a few examples of using SumIF and CountIF in Power BI. There are no SumIF and CountIF functions in DAX. However, you can work around it using several different ways. Watch our short video tutorial to find out...
VIDEO: scenario analysis (part 2)

VIDEO: using SWITCH function

In this video, we’ll take a look at the SWITCH function in DAX. The SWITCH function 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 is...