The NOW function returns the current date and time in datetime format. This function is useful for making calculations that depend on the elapsed time or the time that will elapse until a certain event.
NOW()
The NOW function does not accept arguments.
The NOW function returns the current date and time in datetime format.
The result returned by the function is updated only when the column containing the formula in which it is used is refreshed.
The function returns the date and time 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 and time of our computer).
This first example simply returns the date and time of the local computer:
In this example we want to know the time elapsed between each purchase and today, for which the NOW function is used. As the result of the subtraction would be in datetime format, the FORMAT function is used to give it a number format with two decimal places: