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

Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

In this tutorial, we are going to dive into on how to utilize the RANKX function effectively in Power BI. Sometimes you don’t want to show all of the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the

Continue reading

Showcasing Deviations & Trends With Power BI Using DAX

Recently during an Enterprise DNA webinar series session, I dived into how you can showcase deviations in your data in a compelling way. It’s all about setting up compelling visualizations and making sure that we have our results calculated correctly. This is what this video tutorial is all about. I want to showcase how you

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

Segmentation Of Your Data Based On Rankings – Advanced Analytical Technique For Power BI

In this example we’re going to get quite advanced in Power BI using DAX. We are going to try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how

Continue reading