Compare Time Periods with Non-Standard Date Tables – DAX and Power BI

Running time comparison type analysis on custom calendars is a little bit more complex than if you were using a standard calendar. The reason behind this is because the time intelligence functions available for custom calendars allow users to quite easily and effectively write a formula and achieve the results that they want. Unfortunately though, 

Continue reading

Previous Weeks Sales – Advanced Time Intelligence w/DAX in Power BI

Calculating the difference between weekly sales results in Power BI is unfortunately not that easy. The reason behind this is that Power BI doesn’t have a weekly based, built-in time intelligence function. The only available options are for the day, month, quarter, and year. Therefore, to be able to work out weekly results in Power

Continue reading

Average Results Per Month – DAX & Power BI Analysis Technique

In this video tutorial, I dive into some procurement & purchasing type analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may be making. I run through what DAX formula combination you need to be able to calculate averages at a monthly context. I

Continue reading

Procurement Decision Making Models & Analysis In Power BI

Today, we’re going to dive into some purchasing decision-making within organizations. This tutorial showcases the versatility of Power BI to help make insightful decisions for a procurement division. I’m going to run through an intro example where we’ll start from raw data, create a quick data model and then run some analysis. Then I’ll get

Continue reading