Category: DAX

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

How You Can Predict Profitability In The Future Using Power BI

How You Can Predict Profitability In The Future Using Power BI

What I want to cover with this tutorial is an example of how you can predict profitability in the future using Power BI. I wanted to focus more on the concepts of what can be achieved here. In order to actually achieve this in Power BI, what you need is a number of different modelling

Continue reading

How You Can Re-Use Moving Averages In Power BI

How You Can Re-Use Moving Averages In Power BI

In this particular tutorial, we are going to dive into how to showcase trends in your data using moving averages. I want to show you here though how to take this further.¬†How we can re-use the moving averages formula technique in a number of different ways. What’s great about this formula combination or formula pattern

Continue reading

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

In this example, we’re doing a deep dive into budgeting and forecasting inside of Power BI. Specifically, I want to show you how you can allocate budgets (or forecasts) which might be at a monthly or a yearly level, and you need to allocate them to a daily level. This scenario is very common when

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