Forum Discussion
Date Parameters for Filtering and DAX formula
Hi, I am trying to create a report that shows how many users carried out more than X number of "actions" per month over a particular time period. For example, X% of users used the app 5x per month du...
Hi Anonymous ,
I made simple samples and you can check the results below:
Count = var _date1 = MIN('Table 2'[Date]) var _date2 = MAX('Table 2'[Date]) RETURN COUNTAX(FILTER('Table',[Date]>=_date1&&[Date]<=_date2),[ID]) Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))Also this format is for visual:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I made simple samples and you can check the results below:
Count = var _date1 = MIN('Table 2'[Date])
var _date2 = MAX('Table 2'[Date])
RETURN COUNTAX(FILTER('Table',[Date]>=_date1&&[Date]<=_date2),[ID])
Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))Also this format is for visual:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.