Previous quarter not working as expected

[Capstone]

Hi,

Im trying to calculate the previous quarter values for a time series data and it is not working as expected. Im using this formula

Total Cost Prv Quarter = calculate([Total Cost],PREVIOUSQUARTER('Date'[Date]))

It gives correct values when the date row is in months 

But doesnt work when the date row is in quarters as it shows blank values. Any idea how to get it to work for the following table ?

[v-jiascu-msft · Accepted solution]

Hi @Capstone,

It should work. Please check these things below.

1. The New Date and Quarter should be from table "Date";

2. What is the formula of [Total Cost]?

My test below.

Measure =
CALCULATE ( SUM ( Sales[Quantity] ), PREVIOUSQUARTER ( 'Date'[Date] ) )

Best Regards!

Dale

[Capstone]

I solved it. It was an issue with the Date table as I suspected. My Fact table has values for each month for 2014 while my Date table had values from 2012 to 2014. So I filtered it to only include months from 2014 and it worked !