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 | Oct 21, 2020 | Video
In this video, we’ll continue learning about variables in Power BI. Variables are an important feature that makes writing and reading DAX formulas easier, simplify debugging and improve performance. Let’s take a look at syntax, which is very simple. Follow the...
by Nikolai Pavlov | Oct 2, 2020 | Video
In this video, we’ll learn about variables and how to use them to improve calculations in DAX. DAX code can become complex pretty quickly. Therefore, the use of variables can help. Variables in Power BI can help to improve performance, readability, simplify debugging...
by Nikolai Pavlov | Sep 15, 2020 | Video
In this video, we’ll continue to learn about time-intelligence functions in DAX and look at the difference between the Year-to-Date and Running Total calculations. Some people think that the running total calculation is the same as Year-to-Date. However, that is not...
