by Nikolai Pavlov | May 6, 2021 | Articles
In this article, we’ll discuss the benefits of using Power BI dataflows. One of the most common drawbacks of self-service BI implementation is the duplication of data preparation work and inconsistencies across an enterprise. Historically, centralized corporate BI...
by Nikolai Pavlov | Jan 25, 2021 | Video
When using CALCULATE in DAX, you need to always make sure that correct filters are applied. In other words, CALCULATE you can override the existing filter context with the new ones inside the function. Watch our short tutorial above. Basic calculation: First, let’s...
by Nikolai Pavlov | Jan 7, 2021 | Video
In this video, we discuss how to perform a scenario analysis in Power BI using DAX. This is the second part of the tutorial. We’ll build the measures to calculate a percentage change in total sales when certain sales channels are selected. The example shows how...
by Nikolai Pavlov | Dec 27, 2020 | Video
In this video, we discuss how to perform a scenario analysis using DAX in Power BI. In the first part of the tutorial, we analyze how a price change affects total sales. To do this, we’ll build a supporting table with different price values, connect the table to...
by Nikolai Pavlov | Dec 17, 2020 | Video
In this video, you’ll see a few examples of using SUMIF and COUNTIF in Power BI. When Excel users come to Power BI, one of their first questions is “How do I use SUMIF?” Turns out, there are no SUMIF and COUNTIF functions in Power BI. However, with...
