POWER BI: Modeling

Time Intelligence Functions

PARALLELPERIOD function

Returns a single column table of dates that are shifted (offset) by a specified time period either forward or backward in time.

Example Formulas:

Use with CALCULATE to return revenue from two months ago and revenue next month in the current context.

                   Revenue_Two_Months_Ago = CALCULATE(SUM(TransactionData[Revenue]),PARALLELPERIOD(CalenderDate[Date],-2,MONTH))
	            

                  Revenue_Next_Month = CALCULATE(SUM(TransactionData[Revenue]),PARALLELPERIOD(CalenderDate[Date],1,MONTH))
	            

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:

PARALLELPERIOD always returns full periods at the given level of granularity. It only works on YEAR, QUARTER and MONTH level.

Related Formulas or Functions:

• DATEADD