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

Power BI ‘What-If’ Parameter Feature

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

Continue reading

Next Enterprise DNA Learning Summit, Coming Soon – November 2019

Enterprise DNA Free Learning Summit November 2019

The next learning summit is not far away. We’re expecting a large turnout and have some exciting sessions planned. Already we now have close to 1000 Power BI users registered for the event. There will be plenty of new and interesting content that will be covered during this summit. The best thing about it is

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

Power BI Data Sets: Learn How To Detect Abnormal Behavior Using DAX

In this blog post, I will show you in detail how you can discover abnormal patterns of behavior within your Power BI data sets. This is not something that will immediately stand out when running analysis across your data so you have to think quite analytically about it. By thinking deeply about what you want to

Continue reading