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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.