Tag: Advanced analytics

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 New Feature What If Parameters

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

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

Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX

Calculating an average in Power BI can be done in many ways to give you precise information for your business reports. However, sometimes calculating average sales per day may not be enough. You might run into a scenario where you only sell during weekdays. If you run an averaging pattern in Power BI and you

Continue reading

Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days

Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI.  This post will cover a high quality piece

Continue reading