POWER BI: Modeling

Time Intelligence Functions

SAMEPERIODLASTYEAR function

Returns a single column table of dates shifted back one year.

Example Formula:

Find revenue for last year.

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

This does the exact same thing as DATEADD((CalenderDate[Date]),-1, YEAR)