filter 3 months and average

[Pan_Forex]

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.

[devanshi]

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

[v-jianboli-msft · Accepted solution]

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.