Tag: Power BI DAX

Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without

Continue reading

Automatically Find Your Top 3 Salespeople Per Region Using DAX In Power BI

Create Dynamic Lists of Dimensions using DAX in Power BI

There’s so much you can do with DAX in Power BI, and one of these things is for you to be able to find your top 3 salespeople for each region automatically. Picture this too familiar scenario…. You are in a meeting and asked about your sales territories. Who are your top three sales people

Continue reading

The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI

If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. This, by far, is my go-to time intelligence function in DAX at the moment. After going through this post and the

Continue reading

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost

Continue reading

Create Dynamic Cumulative Totals Using DAX In Power BI

Create Dynamic Cumulative Totals Using DAX In Power BI

In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that

Continue reading