PREVIOUSDAY DAX Function (Time Intelligence) Context Transition
Returns a previous day.
Syntax
PREVIOUSDAY ( <Dates> )
| Parameter | Attributes | Description |
|---|---|---|
| Dates |
The name of a column containing dates or a one column table containing dates. |
Return values
Table A table with a single column.
A table containing a single column of date values.
Remarks
The previous day is evaluated considering the first day in the dates argument.
The dates argument can be any of the following:
- A reference to a date/time column. Only in this case a context transition applies because the column reference is replaced by
- CALCULATETABLE ( DISTINCT ( <Dates> ) )
- A table expression that returns a single column of date/time values.
- A Boolean expression that defines a single-column table of date/time values.
The result table includes only dates that exist in the dates column.
Related functions
Other related functions are:
Last update: Jul 1, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
MSDN documentation: https://docs.microsoft.com/en-us/dax/previousday-function-dax