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]) .

 

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

 

Thanks

 

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)

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      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)

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        6 years ago

        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'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) ) )