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...
by Nikolai Pavlov | Aug 16, 2020 | Video
DAX has a variety of time-intelligence functions that help you to build and compare calculations over different time period. With the help of these functions, you can see calculations over days, weeks, months, quarters and years. Let’s take a closer look. In...
by Nikolai Pavlov | Jul 28, 2020 | Video
There are many different ways to use the CALCULATE function in DAX. Depending on a task, you might want to put other DAX functions, such as FILTER and ALL, inside CALCULATE. Two common functions that you put inside CALCULATE are the ALL and FILTER functions. Watch our...
