Calculate Between 320 and 365

[Anonymous]

Hi,

I m using below measures to calculate Total count between 320 and 365 days.Its showing blank value..Is this measure is correct ?

Date'[Date] is calendar table join with Table [CREATED_ON]) .

Age= CALCULATE(COUNT(Table [CREATED_ON]),DATESBETWEEN(Table[CREATED_ON],LASTDATE(DATEADD('Date'[Date],-320,DAY)),LASTDATE(DATEADD('Date'[Date],-365,DAY)) ) )

Thanks

[amitchandak]

@Anonymous , try like

Age=
var _dt =minx('Date','Date'[Date])
var _min =_dt-365
var _max = _dt -320
return
CALCULATE(COUNT(Table [CREATED_ON]),Table [CREATED_ON]>=_min,Table [CREATED_ON]<=_max)

[Anonymous · Accepted solution]

Its working . For older than 1 year .

it should  be  below measure right?

Age=
var _dt =minx('Date','Date'[Date])
var _min =_dt+365
return
CALCULATE(COUNT(Table [CREATED_ON]),Table [CREATED_ON]>=_min)

[v-yingjl]

Hi @Anonymous ,

It's the same principle if the previous measure worked.

Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li

[az38]

@Anonymous 

try

Age= CALCULATE(
COUNT(Table[CREATED_ON]),
DATESBETWEEN(Table[CREATED_ON],DATEADD(LASTDATE('Date'[Date]),-320,DAY),DATEADD(LASTDATE('Date'[Date]),-365,DAY) ) )