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...
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...
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...
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...
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...
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...
