topic Re: filter 3 months and average in DAX Commands and Tips

filter 3 months and average

Pan_Forex — Wed, 21 Jun 2023 19:11:18 GMT

Hello! I have a simple visualization with two columns, player and score.

Score =

VAR _score = AVERAGEX (TOPN (30,'table','table'[id]), 'table'[score])

return _score

I would like my table to include only players who have played a minimum of one [id] in the last 3 months counting from today. A simple filter and setting of the last 3 months will not work in my case.

Re: filter 3 months and average

v-jianboli-msft — Fri, 23 Jun 2023 01:43:46 GMT

Hi Pan_Forex ,

Based on your description, I have created a simple sample:

Please try to apply this measure to the visual's filter:

Flag = COUNTROWS(FILTER('Table',[date]>=EDATE(TODAY(),-3)&&[date]<=TODAY()))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: filter 3 months and average

devanshi — Fri, 23 Jun 2023 06:49:21 GMT

Count of ID = COUNT('Table'[ID])
Maxdate = MAX('Table'[Date])
Minimum Played Player =
FILTER('Table', Count of ID > 0 && Maxdate >= TODAY() - 90 && Maxdate <= TODAY())