Tag: CALCULATE function

Showing Difference Between Sales And Budgets To Date – Forecasting In Power BI

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

Continue reading

Showcase QoQ Sales Using Time Intelligence In Power BI

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

Continue reading

Common Customer Behavior Analysis Using Power BI

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

Continue reading

Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

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

Continue reading

Find Top Customers Using RANKX In Power BI

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

Continue reading