cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Capstone Member
Member

Previous 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 

table.PNG

 

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 ?

 

tablw2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: Previous quarter not working as expected

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] ) )

Previous quarter not working as expected.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-jiascu-msft
Microsoft

Re: Previous quarter not working as expected

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] ) )

Previous quarter not working as expected.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Capstone Member
Member

Re: Previous quarter not working as expected

 

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 !

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors