Forum Discussion

agd50's avatar
agd50
Helper V
3 years ago
Solved

DAX - DistinctCount Previous Quarter Error/Help

  Count of Incident (Previous Quarter) = VAR _Period = -1 VAR _Results = CALCULATE (     DISTINCTCOUNT ( 'Table'[Column] ),     DATESINPERIOD ( 'Dim_Calendar'[Date],     TODAY(),     _...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    agd50 , You can get last qtr based on today, assuming no selection

     

    This Qtr Today =
    var _today = today()
    var _max = eomonth(_today, if( mod(Month(_today),3) =0,0,3-mod(Month(_today),3)))
    var _min = eomonth(_max,-3)+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

    Last Qtr Today =
    var _today = today()
    var _max = eomonth(_today, -1*if( mod(Month(_today),3) =0,3,mod(Month(_today),3)))
    var _min = eomonth(_max,-3)+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

amitchandak's avatar
amitchandak
Super User
3 years ago

agd50 , You can get last qtr based on today, assuming no selection

 

This Qtr Today =
var _today = today()
var _max = eomonth(_today, if( mod(Month(_today),3) =0,0,3-mod(Month(_today),3)))
var _min = eomonth(_max,-3)+1
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Qtr Today =
var _today = today()
var _max = eomonth(_today, -1*if( mod(Month(_today),3) =0,3,mod(Month(_today),3)))
var _min = eomonth(_max,-3)+1
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

agd50's avatar
agd50
Helper V
3 years ago

Very impressive, don't know how you do it. 

Works perfectly