POWER BI: Modeling

Time Intelligence Functions

NEXT functions

Returns a single column table of dates shifted forward by one day, month, quarter or year.

Example Formulas:

Find revenue for next day, month, quarter and year.

                   NextDayRevenue = CALCULATE(SUM(TransactionData[Revenue]),NEXTDAY(CalenderDate[Date]))
	            

                   NextMonthRevenue = CALCULATE(SUM(TransactionData[Revenue]),NEXTMONTH(CalenderDate[Date]))
	            

                   NextQuarterRevenue = CALCULATE(SUM(TransactionData[Revenue]),NEXTQUARTER(CalenderDate[Date]))
	            

                   NextYearRevenue = CALCULATE(SUM(TransactionData[Revenue]),NEXTYEAR(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:

Tip create an additional column which compares the relative percentage difference.