by Nikolai Pavlov | Nov 16, 2020 | Video
The IF function in DAX checks if a given expression is true or false, and returns one value when it’s true, otherwise it returns a second value. In DAX you can write the IF function in two different ways: in columns and measures. The example of creating a...
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...
by Nikolai Pavlov | Sep 4, 2020 | Video
In the previous video, we looked at several basic time-intelligence functions in DAX. Today, we’ll continue to focus on the time-intelligence functions and learn how to calculate the difference between current and last year sales. Time-intelligence functions are...
