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...
by Nikolai Pavlov | Jul 21, 2020 | Video
When people first start with Power BI, they are often confused about the two functions in DAX – SUM and SUMX. Both functions are doing the aggregation and it may be hard to see the difference between the two. In this article, we take a look at the SUMX function...
by Nikolai Pavlov | Jun 28, 2020 | Video
In this video, we’ll continue learning about DAX. Let’s take a look at the function CALCULATE, which is probably one of the most important formulas in DAX. There are many different ways to use this function. In this article, we’ll discuss the basic use...
by Nikolai Pavlov | Jun 21, 2020 | Video
In this video, we will continue learning more about DAX and will build a few basic functions. Let’s focus on the syntax of the language. Take a look at the formula: Name of a Measure = SUM (Table Name [Column Name in the Table]) The above formula equals to the sum of...
