Forum Discussion
Resolver IPrevious quarter not working as expected
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 ?
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
2 Replies
v-jiascu-msftMicrosoft Employee
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 !