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...
VIDEO: scenario analysis (part 2)

VIDEO: Using IF Statement in DAX

The IF function checks if a given expression is true or false, and returns one value when it’s true, otherwise it returns a second value. In Power BI you can write the IF function in two different ways: in columns and measures. The example of creating a...