# Power BI Development Techniques Using DAX Patterns | Enterprise DNA

For this blog, Iâ€™d like to give you an overview of how you can speed up your Power BI development. I always think about ways on how we, at the Enterprise DNA community, can empower ourselves and the Power BI community to develop more quickly inside Power BI. I’ve observed many areas of inefficiencies around development, and Iâ€™d like to share some of the key things that I am doing to speed up my own development. You can watch the full video of this tutorial at the bottom of this blog.

To speed up your development, one of the main things you need to master is what’s called formula patterns. These are DAX patterns that you can reuse over and over again. All it takes is subbing in or changing the parameters within the formulas.

Let’s take a look at some examples.

Table of Contents

## Using Formula Patterns To Speed Up Power BI Development

One of the most common formula patterns that you can see in DAX is the cumulative total. This formula, Cumulative Sales, is an example of a dynamic cumulative total. You can reuse this formula by simply changing the core measure inside this pattern.

And you could sub anything in here depending on what you are analyzing. For example, if I want to analyze the Total Orders, I just sub in the core measure, and then I have a cumulative total of that orders measure.

There’s actually a lot of formula patterns, and you can find them in our learning center – Analyst Hub. We have this app where you can catalog all of your formulas and use them whenever you need.

You can simply copy and paste the formula from the Analyst Hub into Power BI. Instead of having to remember how to exactly write the formula, you can save it here and make it available when you need it.

You can also change the parameters within this formula and come up with a new measure out of it. For example, I want to analyze my Top 5 Product Sales. I just change the parameters of this formula from Locations to Products.

So now I’ve quickly got this measure, and I didn’t even have to think about it. I can then bring it into my report and turn it into a visualization.

Another great formula pattern that you can reuse is the Percent of Sales. You can easily sub in the parameters and create a new measure.

You can go more advanced with your formulas, save them in the Analyst Hub, and then just copy the code to quickly proceed with your Power BI development.

## Conclusion

Using common formula patterns and simply subbing in parameters and core measures are key to speeding up your Power BI development. Using the Analyst Hub to catalog your formula patterns is a huge help in making your work even faster.

You don’t need to write complex formulas every time. These are common patterns that you can reuse in different analyses. With the Analyst Hub, you can just copy and paste these DAX patterns into Power BI. It’s almost effortless.

Watch the full video tutorial below for more examples of the commonly used formula patterns and see how I tweak them a bit and come up with a new measure quickly.

Cheers!

Sam

[youtube https://www.youtube.com/watch?v=198CN5NtrRo&w=784&h=441]

Sam McKay, CFA
Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data driven cultures and create enterprise value by delivering business intelligence training and education.

## How To Merge Queries In Power BI

Merging is another powerful transformation to optimize our...

## Unpacking The Evolution Of Power BI – From Launch to Now

Microsoft Power BI is a dynamic business intelligence platform that has revolutionized the way...

## Finding Patterns In Your Data Using Internal Logic in Power BI

Today Iâ€™m going to showcase how you can discover patterns in your data when using Power BI. This is an...

## Report Builder Tutorial: Sort & Filter Data In Paginated Reports

In this Report Builder tutorial, youâ€™ll learn how to sort and filter the data in your paginated...

## Creating A Pareto Chart In Power BI – Advanced DAX

This blog tutorial showcases a really interesting example around Pareto analysis. Iâ€™m going to teach...

## Power BI Tooltips On Report Images

With the recent Power BI challenges that we run in Enterprise DNA, I've become a huge fan of the Power...

## Best Practices In Using The Q&A Feature In Power BI

The Q&A feature or the natural language feature is seriously one of the most incredible features...

## Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

In this blog post, we'll explore my solution to Problem of the Week #12. For this challenge, we...

## What Is DAX Studio In Power BI Desktop

This tutorial will discuss what DAX Studio is and how it can be used to optimize your DAX codes. DAX...

## DAX Queries Using Variables And Important Functions

This tutorial will discuss about variables, including the FILTER and CALCULATE functions. Youâ€™ll...

## Dynamic Tooltip In Power BI With Embedded Charts

I want to show you an awesome trick for the visualizations in your reports. You can use a dynamic...

## Power Query Features: An Overview

This tutorial will discuss about the available features inside the Power Query Editor. You'll learn how...