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 showcase a
Tag: Budgeting DAX
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
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
When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power
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