Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is

Continue reading

How To Start Using ‘What If’ Parameters Inside Power BI

In this tutorial, I will show you how you can get started with ‘What If’ parameters inside of Power BI. Using this great feature will require you to spend some time thinking quite deeply about the data setup that you currently have in your data model. ‘What If’ parameters have to work over certain values

Continue reading

Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX

Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example

Continue reading

Expanding On Financial Reporting Templates, Next Enterprise DNA Member-Only Event

This week we will have the next scenario-method event from Enterprise DNA. These particular workshop sessions are for enterprise DNA members only. If you are a member and want to find out more about this particular event and register you can at this link below. Expanding On Financial Reporting Templates – September 2018 I’m really

Continue reading

Custom Dynamic Segmentation Using DAX In Power BI

We are going to get advanced with this tutorial. I will cover how you can create Custom Dynamic Groups inside visualizations with Power BI. What do I mean by Dynamic Groups? Think about a scenario where you have a range of different customers and you want to group them into who you judge are good, average,

Continue reading