PREVIOUSDAY DAX Function
The PREVIOUSDAY function returns a table that contains a single column of all dates representing the day that is previous to the first date in the dates column, in the current context.
For example, if the first date in the dates argument refers to June 10, 2009; this function returns a date equal to June 9, 2009.
DAX Syntax PREVIOUSDAY(dates)
The parameter dates is a column containing dates.
Example: The following formula creates a measure that calculates the Previous day income.
DAX
Previous day income = CALCULATE(SUM(Sheet8[Annual Income]), PREVIOUSDAY('Sheet8'[Year]))
The first value is blank for the measure Previous day income because there is no previous day for that row.
