Count between dates

[M_SBS_6]

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?

[M_SBS_6]

Thank you. If I was to add sum(total_app) just I just add that in instead of countrows?

[Daniel29195]

that is correct.

you can any aggregation function you desire (  sum, max, min, count .. ) 

@M_SBS_6 

[Daniel29195 · Accepted solution]

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 🫡👍

[amustafa]

You can create a DAX measure like this.

CountAppIDsInRange =
COUNTROWS(
FILTER(
YourTableName,
YourTableName[app_date] >= DATE(2023, 1, 1) && YourTableName[app_date] <= DATE(2024, 6, 1)
)
)