Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate Between 320 and 365

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]...
data protection
General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

try

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