The TODAY function returns the current date in datetime format. The time returned by this function is always 00:00:00. This function is useful for making calculations that depend on the number of days elapsed or the number of days that will elapse until a certain event.
TODAY()
The TODAY function does not accept arguments.
The TODAY function returns the current date in datetime format. The returned time is 00:00:00.
The function returns the date of the server or computer where the Power BI file is hosted (if we are running Power BI Desktop, the function will return the date of our computer).
This first example shows the current date:
This second example shows the number of weeks elapsed from the sale date to today (calculation involving the DATEDIFF and TODAY functions):