Need help with SAMEPERIODLASTYEAR

[Anonymous]

Hi, I am having trouble understanding why my formula is returning incorrect value for Q3 2019 only. 

The formula is the following:

ReturnRateSamePeriodLY = CALCULATE([TotalNetUnits]/[TotalDeliveredNetUnits]| SAMEPERIODLASTYEAR('Time'[PK_Date]))

I broke the numbers down by month and the numbers seem correct, but when it tries to aggregate the values by quarter, the value for Q3 2019 is incorrect. Same QTR PY Return rate in the smaller table should have a value of 0.55% not 0.71%. 

Appreciate any clarification on this! 

[Anonymous]

Yeah... We are also having trouble understanding your figures. Maybe because we don't know the model?

Best
Darek

[Anonymous]

Hi! The small table "QTR on QTR Return/Exchange Rate Variance" I am showing the return rate for Quality only, for the current quarter and corresponding quarter in the previous year. In the table above, you can see that the value for Q3 2019 for Quality is 0.56% and value for Q3 2018 for Quality is 0.55%, but in the "QTR on QTR Return/Exchange Rate Variance" the value is showing 0.71% instead of 0.55%. 

To compute the return rate "Same QTR PY (previous year) Return Rate", I am using the formula shown in the original post.  

When I break down the values by month, the return value seems to be correct, however, when I try to show in on the quarterly level in the "QTR on QTR Return/Exchange Rate Variance" table, the value is not aggregating correctly.

As you can see in the above table, the values per month for the month and the same month in the previous year are correct. 

Thanks!