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.

 

These are measures referenced below

 

Alarms Total = COUNTROWS(system)
Response Avg = AVERAGE(system[ResponseTime])

Count for Current Quarter - works

 

 

Alarms QTD = TOTALQTD([Alarms Total],'Date'[Date])

Count for Previous Quarter - works - yes the dates are manual for testing this

 

Alarms Prev Qx = 
CALCULATE(
    [Alarms Total],
    FILTER (
       ALL(system),
        AND( 
           system[AlarmTime].[Date] >= date("2017","10","1"),
            system[AlarmTime].[Date] <= date("2017","12","31")
        )
    )
)

Count for Previous Quarter - doesn't work (blank)

 

Alarms Prev Q =
CALCULATE (
    [Alarms Total],
     PREVIOUSQUARTER('Date'[Date])
)

Average this Quarter to date - works

 

Response QTD Avg = TOTALQTD(AVERAGE(system[ResponseTime]),'Date'[Date])

Average for Previous Quarter - works - again manual dates for testing

 

Response Prev Qx Avg = 
CALCULATE(
    [Response Avg],
    FILTER (
       ALL(system),
        AND( 
           system[AlarmTime].[Date] >= date("2017","10","1"),
            system[AlarmTime].[Date] <= date("2017","12","31")
        )
    )
)

Finally, Average for Previous Quarter - doesn't work (blank)

Response Prev Q Avg =
CALCULATE ( 
    AVERAGE ( system[ResponseTime] ),
     PREVIOUSQUARTER( 'Date'[Date] )
)

 

9 Replies