Tag: Power BI Trend Analysis

Projecting The Current Trend in Your Power BI

In this unique example, I want to show you how to project a historical trend in Power BI and repeatedly project it forward. This particular example came from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world using historical information, which could

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

Running Totals in Power BI: How To Calculate Using DAX Formula

Sometimes calculating running totals in Power BI is a far better away to analyse trends than just looking at actual results on a daily basis. That’s why I’m going to show you in this example how you can implement a running total calculation which is dynamic, and flows and integrates well with the rest of

Continue reading