Tag: Cumulative Total Pattern

DAX Cumulative Total Pattern In Power BI

total-pattern-in-power-bi

I’m going to show you some great resources and tips around DAX cumulative total pattern. These are helpful in a number of scenarios you’ll be facing as you continue to work on reports and dashboard within Power BI. You may watch the full video of this tutorial at the bottom of this blog. You can

Continue reading

Combining DAX Patterns Or DAX Formulas In Power BI

For this tutorial, I’ll be showing you how to combine multiple DAX patterns in Power BI. This strategy is one of the many applications of measure branching and is an effective way of producing high-quality reports. You may watch the full video of this tutorial at the bottom of this blog. When your goal is

Continue reading

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The difference between ALL and ALLSELECTED DAX functions can be relatively confusing when you’re starting out with Power BI. In this tutorial, I’ll quickly go over the main differences between those two commonly used DAX functions and their respective usages in your Power BI reports. You may watch the full video of this tutorial at

Continue reading

Calculating A Cumulative Run Rate Using DAX In Power BI

When analyzing actual results in your data, you may sometimes want to compare it to a forecast or run rate. In this tutorial, I’ll show you how to calculate a cumulative run rate based on some historical results. You may watch the full video of this tutorial at the bottom of this blog. This came out

Continue reading

Showcasing Budgets In Power BI – DAX Cumulative Totals

Recently, I built and showed a Budgeting Analysis Dashboard in one of Enterprise DNA’s workshop. One feature of that Dashboard is the Cumulative Budget view. The webinar is linked here. You may watch the full video of this tutorial at the bottom of this blog. The dashboard itself is dynamic so I can change the

Continue reading