Category: Time Intelligence

Using ‘What-If’ Parameters in Power BI

What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a popup box

Continue reading

Tracking Trends in Power BI Using DAX Formulas

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this example I show you how you can use the conditional formatting inside Power BI tables to showcase this type of insight really well. Obviously to show growth trends we actually need to calculate

Continue reading

Discovering Advanced Insights in Power BI – Free Workshop Preview

For the first webinar series session of the year I thought I would dive into some more advanced concepts around Power BI development. To learn more about the event and to register click here – Webinar Registration To get advanced in Power BI you first have to start using DAX formulas. Hopefully this is a

Continue reading

Running Totals Example In Power BI Using DAX Formula

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

Continue reading