Tag: AVERAGEX

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

In this tutorial, I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. You may watch the full video of this tutorial at the bottom of this blog. Virtual tables are the essential ingredient to creating advanced logic in Power BI. There’s

Continue reading

Power BI Data Visualization Tips For KPI Trends Analysis

In this tutorial, I’ll show you a Power BI data visualization technique on highlighting KPI (key performance indicators) trends in your report. You may watch the full video of this tutorial at the bottom of this blog. The data and dashboard I’m using for this demonstration was part of the Enterprise DNA Learning Summit in

Continue reading

Using Moving Averages To Show Trends in Power BI

In this blog post, I want to dive into trend analysis. Specifically, how to highlight trends in Power BI really effectively using moving averages. You may watch the full video of this tutorial at the bottom of this blog. The concepts that I go through here are techniques you might have already touched on yourself in

Continue reading

Using Advanced Logic In Power BI To Correct Your Totals

Many times when you get into more advanced formula with DAX, you’ll find that the totals that show up either on a table or a card can sometimes be incorrect. There are so many variations of how this could eventuate in your formulas so it’s hard to cover every single scenario. In this tutorial, I

Continue reading

Calculate Average Per Customer Transaction Using DAX In Power BI

What I want to demonstrate in this tutorial is how we can calculate average sales, profits, or transactions per certain dimension inside of DAX in Power BI. You may watch the full video of this tutorial at the bottom of this blog. In this particular example we’re going to look at it from a customer’s

Continue reading