Centida’s blog

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.

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.

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!

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

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.

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

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

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

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

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