Category: DAX

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

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

Power BI Custom Calendars: Calculating For Month On Month Change – 445 Calendars

This tutorial is about how you can run time intelligence calculations over custom calendars in Power BI. This is really relevant to those who deal with 445 calendars, which is a very common scenario for Power BI users. Not all businesses out there work to a standard calendar around financial years or calendar years. Sometimes

Continue reading

Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without

Continue reading