Forum Discussion

misterian's avatar
misterian
Regular Visitor
8 years ago

PREVIOUSQUARTER returns nothing

Hello, this really has me stumped as everything else works OK! I can count and average if I put in manually the dates and the current quarter time intellignce works but not the previous quarter ones....
Need Help
misterian's avatar
misterian
Regular Visitor
8 years ago

Thanks, that makes sense. So what good is previous quarter? Can I feed a context from as the current date to the previous quarter or just find a different way to do this without previousquarter. Quarters are a little harder than years and months because quarters may "overlap" years.

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
8 years ago

I usually prefer to put slicers on the page for Year/Quarter/Month so people can interact with report, but you can do this:  

 

Response Prev Q Avg = 
var _today = FILTER( VALUES( 'Date'[Date] ), 'Date'[Date] = TODAY() )
RETURN
CALCULATE ( AVERAGE(system[ResponseTime]), PREVIOUSQUARTER( _today ) )