cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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
Microsoft
Microsoft

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
Microsoft

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

 

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
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors