Power BI Grouping Technique: Aged Trial Balance Using DAX

We’re going to explore a really unique Power BI grouping or segmentation example in this tutorial. We’ll create an aged trial balance grouping inside Power BI. This technique involves re-using many of the grouping and segmentation patterns that we already learned. Utilizing Power BI grouping patterns for this unique example is no different. The idea

Continue reading

Power BI Budgeting Technique: Allocating Monthly Budgeting Sensitivity Table

In this blog, I talk about a technique around Power BI budgeting, working out a way to allocate calculations across different time frames or months, for example. In most cases, budgets are in a yearly basis. However, it’s so much better to narrow it down to a monthly basis and see the allocation of our

Continue reading

Complete Refresh For Ultimate Beginners Guide To DAX

Recently, we’ve put the finishing touches on this course module and completed a comprehensive upgrade to the Ultimate Beginners Guide to DAX course module.  This is a completely free course available to anyone connected to Enterprise DNA.  To enroll in this course now, check out the link below.  Ultimate Beginners Guide to DAX There’s been quite a few changes to Power BI over the last 12 to 18

Continue reading

How to Compare Current Sales to Previous Best Month in Power BI

In this tutorial, we’re going to learn more about the advanced time intelligence feature in Power BI to compare current sales to the previous best month. This is actually a unique question that was raised at the Enterprise DNA Support Forum. And as soon as I heard it, I thought wow! We can actually do

Continue reading

Identify & Showcase Data Outliers In Power BI Using DAX

We are going to take Power BI development to the next level and discover important new trends in our data. First, we need to dive into our data outliers through some advanced logic in Power BI using DAX. I’ll help you understand the difference between raw and filtered contexts. So, we’re going to analyze and

Continue reading