Parallelperiod -1 showing values from -3 months ago on Matrix table

[Ade108]

Hi all,

I have a matrix table showing MoM variance between complaints received last month (-1) and the previous month (-2) as shown in the picture below. 

I've just discovered however that the 'Journey' rows highlighted in yellow were actually 0 complaints for December and the matrix is showing the last month when there was a complaint (October). 

The measures I have used to create this are:

MTD Complaints = TOTALMTD(SUM(Results[Complaint Count]), Results[case_created_dateonly])

Last Month = CALCULATE(MeasuresTable[MTD Complaints], PARALLELPERIOD(Results[case_created_dateonly],-1,MONTH))

Previous Month = CALCULATE(MeasuresTable[MTD Complaints], PARALLELPERIOD(Results[case_created_dateonly],-2,MONTH))

Can anyone advise where Im going wrong with this? I need the matrix to show '0' if there were no complaints received either last month or previous month.

Many thanks

[Ade108]

Thanks for such a quick response

I remember now that although I have a date table, it is marked as a date table and is linked to the fact table...when I try to use the DATESMTD measure it returns 'blank'.

I will watch those videos you have supplied - thanks

[amitchandak · Accepted solution]

@Ade108 , You should always use date table in measure, visual and slicer for such cases

examples 

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

Refer Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Ade108]

I have just rechecked your advice and it now works - many thanks 🙂