Category: Time Intelligence

How To Create Budgets Which Have Seasonality Adjustments – Power BI Technique

We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from

Continue reading

How To Calculate Budget Or Forecast Results Cumulatively In Power BI

Recently I ran an entire workshop as part of the Enterprise DNA webinar series on Advanced Budgeting Techniques. I know for a fact that there’s a huge requirement for this type of analysis in Power BI. Very often we have our actual results and we want to compare them to a forecast or a budget

Continue reading

Averages Per Customer Transactions – DAX in Power BI

What I want to showcase in this tutorial is how we can calculate the average amount of sales, profits, or transactions per certain dimension inside our Power BI models and reports. In this particular example we’re going to look at it from a customer perspective. We’re going to try and analyze, what’s the average sales

Continue reading

Predict Future Profitability within Power BI Using DAX

In this video tutorial, I will showcase some of the analytical work I enjoy completing the most in Power BI..that is working on future predictions.  I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future profitability and one that

Continue reading

When Did Your Customers Make Their Last Purchase? – DAX Techniques in Power BI

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success.  In this video tutorial, I am going to demonstrate how you can work out how many days it has been since a customer last purchased

Continue reading