Select Page

Centida’s blog

Business Intelligence for Financial Management applications

Using CALCULATE in DAX (Intermediate)

When using CALCULATE it’s all about making sure that correct filters are applied. With CALCULATE you can override the existing filter context with the new ones inside the function. Watch our short tutorial below.

VIDEO: Scenario Analysis in Power BI (part 2)

In this video, we’ll learn how to 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 sales channels affects the overall sales.

VIDEO: Scenario Analysis in Power BI (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.

Using SUMIF and COUNTIF functions in Power BI

When people come from Excel to Power BI, they’re surprised to learn that there are no SUMIF and COUNTIF functions in DAX. In this short video, we show how you can substitute SUMIF and COUNTIF using a few different solutions. Enjoy!

Using SWITCH function in DAX

In this video, we’ll take a look at the SWITCH function in DAX. Check out the advantages of SWITCH over the IF function.

VIDEO: Scenario Analysis in Power BI (part 2)

In this video, we’ll learn how to 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 sales channels affects the overall sales.

VIDEO: Scenario Analysis in Power BI (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.

Using SUMIF and COUNTIF functions in Power BI

When people come from Excel to Power BI, they’re surprised to learn that there are no SUMIF and COUNTIF functions in DAX. In this short video, we show how you can substitute SUMIF and COUNTIF using a few different solutions. Enjoy!

Using SWITCH function in DAX

In this video, we’ll take a look at the SWITCH function in DAX. Check out the advantages of SWITCH over the IF function.

Using IF Function in DAX

Watch our short and simple explanation of using the IF function 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.

VIDEO: Using Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.

VIDEO: Introduction to Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.

VIDEO: Year-to-Date vs Running Total

In this video, we’ll continue to learn about time-intelligence functions in DAX and look at the Running Total calculation.

VIDEO: Time-Intelligence Functions (Part 2)

In this video we’ll learn how to calculate the difference between this year and last year sales.

VIDEO: Basic Time-Intelligence Functions

In this video, you’ll learn how to use the SAMEPERIODLASTYEAR, YTD and MTD functions inside the CALCULATE.

Using SWITCH function in DAX

In this video, we’ll take a look at the SWITCH function in DAX. Check out the advantages of SWITCH over the IF function.

Using IF Function in DAX

Watch our short and simple explanation of using the IF function 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.

VIDEO: Using Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.