In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical
This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This
AVERAGEX in Power BI is an incredibly versatile function. It’s not just for averaging values; it’s also great for trend analysis. I discussed the use of AVERAGEX for trend analysis in the Enterprise DNA Learning Summit. A link to the event can be found below. But in this post, I’m going to focus more on
In this tutorial, I’ll show you a Power BI data visualization technique on highlighting KPI (key performance indicators) trends in your report. The data and dashboard I’m using for this demonstration was part of the Enterprise DNA Learning Summit in 2018. You can incorporate this technique in your own reports inside Power BI. It’s a
In this blog post, I want to dive into trend analysis. Specifically, how to highlight trends in Power BI really effectively using moving averages. The concepts that I go through here are techniques you might have already touched on yourself in the past. But I wanted to show how important it is from a visualization perspective
