TODAY Function (DAX)

How does the TODAY function (DAX) work?

The TODAY function (DAX) returns the current date.

TODAY Formula Syntax


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




Related DAX Functions


Related Course Modules