There is a table visual that displays Total Sales each quarter and the corresponding sales for the previous quarter from the Sales table.
The two measures used in the table are defined as below:
Total Sales =
CALCULATE ( SUM ( Sales[Sales Amount] ) )
Sales Last Quarter =
CALCULATE ( [Total Sales], PREVIOUSQUARTER( ‘Date‘[Date] ) )
Due to the workings of the PREVIOUSQUARTER DAX function, a blank value appears for Total Sales in the last row when you add the Sales Last Quarter measure to the visual.
How would you rewrite the measure for Sales Last Quarter in order to avoid this blank value? Select two options.