Parallelperiod measure last year with no data current year

[Mengeltje]

Hi there,

in my report I've created the measure parallelperiod. What I need is the actuals of this year in comparison with the actuals of last year over the months. Because there is no data of this year for July and further the measure shows no data for these months for last year.

The measure is: 

LastYear = CALCULATE(SUM(Calls[Aangeboden oproepen]), PARALLELPERIOD('Date'[Date],-1,MONTH))

There is a print screen attached. 

What I need is the whole of last year and the actuals of this year till the current month.

Thank you for your advice.

[v-jingzhang · Accepted solution]

Hi @Mengeltje 

Use the Date column from Date table into the Matrix. And you may consider using SAMEPERIODLASTYEAR or DATEADD functions to get the same result.

Time Comparisons In Power BI: This Year vs Last Year | Enterprise DNA

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question - RADACAD

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.