Time Comparison For Non Standard Date Tables In 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 with non-standard

Continue reading

Calculating Weekly Sales 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. I’ll show you with the DATEADD function in this formula. This function

Continue reading

Next Enterprise DNA Learning Summit, Coming Soon – February 2020

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

Analyzing Average Results Per Month Using DAX In Power BI

In this tutorial, I go through an average results analysis technique. I dive into some types of procurement & purchasing analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may make. I go through which DAX formula combination you need to be able to

Continue reading

Procurement Decisions Model And Analysis In Power BI

In this tutorial, we’re going to dive into some procurement analysis or purchasing decision-making within organizations. This tutorial demonstrates the versatility of Power BI when it comes to helping 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,

Continue reading