TODAY Function (DAX)

How does the TODAY function (DAX) work?

The TODAY function (DAX) returns the current date.

TODAY Formula Syntax

TODAY (
     
)

How do you use the TODAY function?

The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.

Related Blog Posts

Related Support Forum Posts

Today vs Yesterday
How to showcase Budgets vs Actuals to today’s date
Urgent help needed – sum up sales forecast from today thru end of month

Considerations when using the TODAY function

  • If you need a static date that won’t change, you can enter the current date using the keyboard shortcut Ctrl + ;
  • If you need current date and time, use the NOW function.

Related Video Tutorials

Formula examples using the TODAY function

=YEAR(TODAY())-1963

=TODAY()+7

=TODAY()+5

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership