• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / DATEADD

DATEADD

posted on August 23, 2017

« Back to Glossary Index

Syntax

DATEADD(<dates>,<number_of_intervals>,<interval>)

Tutorial with example

DATEADD is a really useful function to create sets of dates backwords or forward from a point in time. It is used for Previous date calculations.
In this video, I show you how it works.

Link to DAX Studio: https://daxstudio.codeplex.com/

Download example file:

Link to YTD video and Power BI file: https://www.youtube.com/watch?v=5WGOTsYngCI

Bonus video:

PARALLELPERIOD VS DATEADD DAX functions

Remarks

The dates argument can be any of the following:

  • A reference to a date/time column,
  • A table expression that returns a single column of date/time values,
  • A Boolean expression that defines a single-column table of date/time values.

The result table includes only dates that exist in the dates column.

If the dates in the current context do not form a contiguous interval, the function returns an error.

This DAX function is not supported for use in DirectQuery mode.

Was this helpful?
[Total: 0   Average: 0/5]
Related Articles:
  • The ultimate dashboard to track your website growth with Google Analytics and Power BI (supercharged Excel)
See Also:
  • PARALLELPERIOD
  • SAMEPERIODLASTYEAR
« Back to Index

Reader Interactions

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In