Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 I should also note that I don't think that tooltip is correct.