POWER BI: Modeling

Time Intelligence Functions

PREVIOUS functions

Returns a single column tables of dates shifted back by one day

Example Formulas:

Return the previous day, month, quarter and year revenue

                   PreviousDayRevenue = CALCULATE(SUM(TransactionData[Revenue]),PREVIOUSDAY(CalenderDate[Date]))
	            

                   PreviousDayRevenue = CALCULATE(SUM(TransactionData[Revenue]),PREVIOUSDAY(CalenderDate[Date]))
	            

                   PreviousQuarterRevenue = CALCULATE(SUM(TransactionData[Revenue]),PREVIOUSQUARTER(CalenderDate[Date]))
	            

                   PreviousYearRevenue = CALCULATE(SUM(TransactionData[Revenue]),PREVIOUSYEAR(CalenderDate[Date]))
	            

Power BI Demo:

How to Make:

• In Power BI Desktop create a new measure using the formulas above.
• Under visualizations select table
• Select or Add in the date column (i.e CalenderDate[Date]) from the calendar date table.
• Select or Add in the new measures to the values section

Additional Comments:

Shows PREVIOUS function in different contexts

Related Functions and formulas:

• NEXT