Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI

by | 1:00 pm EDT | October 09, 2019 | Business Intelligence, DAX, Power BI

If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. You may watch the full video of this tutorial at the bottom of this blog.

This, by far, is my go-to time intelligence function in DAX at the moment. After going through this post and the video below, it surely will be your favorite too.

This detailed blog will go through all the various aspects of how to set up time comparison analysis with this function.

You can download the Power BI (pbix) file below and follow along throughout the video. Just let us know where to send the file.

## Using the DATEADD Function in Power BI

In this blog, we will use the total sales measure as an example in showing how the DATEADD function can be utilized.

You’ll see how you can compare the sales this year with the sales last year.

But since using DATEADD allows you to compare a measure to any time period, you can look at other time periods such as day, month, or quarter.

Just by making a few tweaks in the formula, like changing the number of months or replacing month with quarter, you can easily have the data you’re looking for.

I think you’ll be amazed at how easy it is to actually do this type of analysis using DAX in Power BI.

## Other uses of the DATEADD Function

The usefulness of the DATEADD function does not end with comparing total sales at different time periods. You can actually use it for any metric that you want to look into. For instance, it can be used when calculating the following:

1. Percentage change
2. Difference between time periods
3. Cumulative sales

So, try this out and see how the DATEADD function can be useful to you.

***** Related Links *****
Time Intelligence For Non Standard Date Tables In Power BI
Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX
Discover How To Repeatedly Project A Current Trend Forward In Power BI

## Conclusion

In this post, you’ve seen why the DATEADD is simply the best and most versatile time intelligence function in Power BI.

Not only can you use it to compare a metric to any time period but changing time periods is also really easy. DATEADD can also be used in many other types of calculation.

I’m hoping that from grabbing the download and watching through the video below you’ve now got a much better understanding of how great the DATEADD function is.

Some recommended links for you so you can dive into time intelligence techniques inside of Power BI:

Previous Weeks Sales – Advanced Time Intelligence w/ DAX in Power BI
Create Dynamic Forward Forecasts in Power BI with DAX

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...

## How Many Rows Can Tableau Handle?

Are you dealing with a large data set? Are you wondering how many rows can Tableau handle efficiently?...

## How to Update Tableau in 4 Quick Steps

With frequent updates and new releases, Tableau continues to evolve and improve its functionality. To...

## 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...

## What is Context Filter in Tableau? How to Apply and Set

One of the powerful features of Tableau is its ability to allow users to interact with data...

## How to Number Columns in Excel Automatically: 5 Quick Ways

In Excel, numbering columns is an important and straightforward process that can help you organize and...

## How to Make a Logo Transparent in PowerPoint: Quick Guide

A transparent logo can be a powerful tool in your branding arsenal. It allows your logo to seamlessly...

## Excel Waterfall Chart: Guide to Create, Design & Impress

Have you heard of an Excel waterfall chart but are unsure how to create one and make it stand out?...

## Tableau Tooltip: A Design Guide for Customization

Are you ready to use Tableau tooltips to level up your visualizations and make them more insightful and...

## What is a Set in Tableau and How to Create Them: User Guide

Are you getting started with Tableau and looking to create a set? Well, you're in the right place. In...

## How to Alternate Colors in Excel: 3 Top Ways Revealed

Knowing how to alternate colors in Excel can be a game-changer; there's little more satisfying than a...