Tag: AVERAGEX

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. 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

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. In this particular example we’re going to look at it from a customer’s perspective. We’re going to try and analyze what the average sales are we make per

Continue reading

Common Customer Behavior Analysis Using Power BI

In today’s business world, conducting common customer behavior analysis is of utmost importance for many functional areas within companies. Analyzing consumer behavior serves as a tool to help plan and meet sales objectives. Additionally, understanding buyer behavior helps decide where and how to better position products or services. You can evaluate how your customers act

Continue reading

Iterating Functions In DAX Language – A Detailed Example

For this blog post, I want to dive into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just

Continue reading