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...
by Nikolai Pavlov | Jun 12, 2020 | Video
In this video we discuss the fundamentals of DAX, a powerful formula language used in Power BI. Experienced Power BI users swiftly change between Power Query’s M language and DAX, depending on tasks at hand. We will not be getting into the nitty-gritty details of...
by Nikolai Pavlov | Jun 5, 2020 | Video
In this video, we discuss the calendar table in Power BI. When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions. In this...
by Nikolai Pavlov | May 27, 2020 | Video
In this video, we will discuss how to clean and format a sales table using Power Query. Bad data is a big pain for everyone. Data analysts spend most of their time cleaning data, as it rarely comes in the format they need. Power Query comes as a perfect solution to...
