Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# DAX Function Review: Using PARALLELPERIOD In Power BI

by | 9:00 am EDT | April 03, 2020 | Power BI

Let’s really go deep into DAX formula with the Power BI PARALLELPERIOD function. We’ll look into this amazing DAX function and see how to use this in quite an effective way inside some calculations. You may watch the full video of this tutorial at the bottom of this blog.

You might also find some other usages different to what I’m going to demonstrate in this DAX function review. I’m going to walk through the logic and show you how it works.

## How PARALLELPERIOD Works

PARALLELPERIOD is a time intelligence function.  So what it does is it goes back to a time window that we specify, and then does a full calculation of that particular time window.

In this sample calculation, we’re looking back one year. PARALLELPERIOD inside this calculation is jumping back one year, then looking at that entire year and summing up that entire year’s sales

We drag this into our table and we see the results on every row. This \$11,565,545 is the Total Sales in 2016, while the \$11,690,763 is the Total Sales in 2015, which is set here as the Prior Sales.

If we look at 2017, the \$11,565,545 Total Sales of 2016 becomes our Prior Sales.

We can also do this by quarter. We simply change Year in the formula to Quarter and we have a slightly different result.

Another example is that we can also go “plus” (+) instead of “minus” (-). So we could go plus quarter or plus year.

From here, we could also do some simple measure branching and work out some percentages of totals.

## Working Out Percentages of Totals

We bring in our Cumulative Sales to calculate the percentages of our totals. We’re going to find out, through this year, how we go based on our last year’s results. This is quite an interesting analysis from a percentage perspective.

That’s exactly what I’ve done here. The formula is not difficult at all. We’re simply implementing measure branching effectively. We branch out into this additional logic.

And so if we drag this into our table, it adjusts or changes through time and we can see that we ended up 103% over what we were last year.

We can also show this in a visualization.

## Conclusion

Here I showed you a perfect example of when and how to use the Power BI PARALLELPERIOD. I also demonstrated how we can branch out into more calculations from our core measures.

The key concept of how PARALLELPERIOD works is that it opens up a time window based on what we specify. It goes and looks back in any particular context and returns that entire year’s or quarter’s or month’s result.

The great thing about this DAX function is how easy it makes us do this dynamically using filter functions. There would be a lot more to it. Maybe a slightly longer formula, but it’s a great time intelligence function.

Explore more on this function and apply it to your work. Cheers!

Sam

## How to Calculate Age in Excel: 5 Best Methods Explained

Looking to calculate age in Excel? Well, you're in the right place. Whether you need to find the age of...

## Funny ChatGPT Prompts: 20 Hilarious ChatGPT Ideas

In a world where technology continues to amaze us, we have now arrived at the point where we can have a...

## Power BI Slicer Search: User Guide With Examples

Ready to get started with the Power BI slicer? This feature will allow you to filter and slice your...

## SUMPRODUCT Multiple Criteria: Explained With Examples

Most Excel users think that the SUMPRODUCT function in Excel helps only to multiply the numbers in...

## Data Analytics Outsourcing: Pros and Cons Explained

In today's data-driven world, businesses are constantly swimming in a sea of information, seeking the...

## How to Embed Power BI in Sharepoint: 4 Simple Steps

Embedding Power BI reports in SharePoint Online is a powerful way to display interactive data...

## The Top 5 Power BI Alternatives in 2023

Power BI has established itself as a powerful business analytics platform, offering a wide range of...

## Power BI Waterfall Chart: A Detailed User Guide

In the world of data visualization, charts speak louder than numbers. If you're looking for a way to...

## Power BI Import vs Direct Query: Which is Better & Why?

In the world of data analysis, Power BI offers you a range of tools to connect to your data sources....

## Power BI Certification: Everything You Need to Know

In today's data-driven world, the ability to transform raw numbers into meaningful insights is more...

## Power BI Bookmarks: The Ultimate Guide

When working with data, bookmarks offer a streamlined and personalized way to navigate through large...

## Power BI Default Slicer Value Explained

One of the key features of Power BI is the slicer, which allows you to filter your data based on...