The topic that I’m going to discuss in this tutorial was part of a full hour workshop on budgeting and forecasting in Power BI during an Enterprise DNA Learning Summit. This tutorial focuses on how we calculate and highlight the differences between cumulative sales and cumulative budgets up to a certain date only. Firstly, I’ll
In this tutorial, we’re going to cover how to calculate quarter on quarter sales differences using time intelligence in Power BI. We’re not just going to do it at a granular level- we are going to try and analyze trends based on quarter on quarter sales. Sometimes when you are looking at something from a
In today’s business world, conducting common customer behavior analysis is of utmost importance for many functional areas within companies. Analyzing consumer behavior serves as a tool to help plan and meet sales objectives. Additionally, understanding buyer behavior helps decide where and how to better position products or services. You can evaluate how your customers act
It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without
Power BI is an amazing analytical engine! In this blog post, I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. I
