Tag: Budgeting DAX

Showcasing Budgets In Power BI – DAX Cumulative Totals

Recently, I built and showed a Budgeting Analysis Dashboard in one of Enterprise DNA’s workshop. One feature of that Dashboard is the Cumulative Budget view. The webinar is linked here. The dashboard itself is dynamic so I can change the time frame and select the products I want to track. This makes exploring the data

Continue reading

Advanced Product Budgeting – Actual Results To Budgets Per Product

I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get

Continue reading

Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX

In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on historical information and complete it in an automatic way. When you create budgets and forecasts, sometimes you may have to go through a very comprehensive process. I’m going to demonstrate a

Continue reading

Enterprise DNA Learning Summit August 2019 – Second Day Wrap Up

Another 2 sessions completed today with a great turnout once again. We stepped things up a level today with a detailed review of CALCULATE vs CALCULATETABLE and DAX Formula Combinations While some of the concepts might have been new to those who attended, the great thing I feel is how achievable they are for all

Continue reading

Enterprise DNA Learning Summit May 2019 – Second Day Wrap Up

Enterprise DNA Learning Summit May 2019 - Second Day Wrap Up

Another 2 sessions completed today with a great turnout once again. We stepped things up a level today with a detailed review of advanced grouping techniques and also a real-world logistics optimization scenario While some of the concepts might have been new to those who attended, the great thing I feel is how achievable they

Continue reading