Tag: Time Intelligence Calculations

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

Power BI Custom Calendars: Calculating For Month On Month Change – 445 Calendars

This tutorial is about how you can run time intelligence calculations over custom calendars in Power BI. This is really relevant to those who deal with 445 calendars, which is a very common scenario for Power BI users. Not all businesses out there work to a standard calendar around financial years or calendar years. Sometimes

Continue reading

Power BI Trend Analysis: Are Margins Expanding Or Contracting?

In this blog post, I will be diving into a relatively specific insight by conducting a Power BI trend analysis. By walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of measure branching, which I love

Continue reading

How To Do Trend Analysis In Power BI Using DAX

Power BI Tracking and Visualizing Trends

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this post, I will show how to use conditional formatting inside Power BI tables to showcase this insight really well. Obviously to show a trend analysis in Power BI, we actually need to calculate

Continue reading

Predict Future Profitability Within Power BI DAX Functions

In this blog post, I will showcase some of the analytical work I enjoy doing the most… and that is working on future predictions using Power BI DAX functions. I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future

Continue reading