Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Count between dates

Hi, I need to count app_id where date range app_date is between 01/01/2023 and 06/01/2024.   Any idea how to write this out please?
  • Daniel29195's avatar
    2 years ago

    hello M_SBS_6 

     

    use this measure : 

    measure = 
    calculate( c

    count(table_name[app_id] ,

    appdate >="01/01/2023" && appdate >="06/01/2024"
    )

     

    now the problem is that this measure is fix to this date. 

     

     

    what i would recommend to do, is to use the custom slicer : 

     

    and use this measure instead  :  measure =  count(table_name[app_id])

    and use the measure to select the date period to want to display the count for.

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍