Filtering out members of a field only after a specific date

[trevordunham]

Hello,

I have some data where I need to filter out members of a field after Q2 of this year. The date field is just quarter so not an actual date field if that changes anything.

IE:

Field (Team) = A,B,C,X,Y,Z

I need my data to contain all teams prior to Q3 but in Q3 and onward teams Y and Z are filtered out. 

Thanks

[Anonymous · Accepted solution]

Hi  @trevordunham ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Flag =
var _today=TODAY()
var _Qu=QUARTER(_today)
return
SWITCH(
    TRUE(),
    _Qu>2 && NOT(MAX('Table'[Field])) in {"Y","Z"} ,1,
    _Qu<=2 && MAX('Table'[Field]) in SELECTCOLUMNS('Table',"Field",'Table'[Field]),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Today is the third quarter, and Y and Z will not be shown on Legend

Best Regards,

Liu Yang

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

[AliceW]

Hi Trevor,

Not clear about the place you want to filter them. Is it in a table visual in a report?

How's the data structure? Like, one table with columns 'Member' and 'Quarter' and presumably 'Activity' or 'Invoices'?

[trevordunham]

Yes, these are just a few different line and bar graphs I would like to filter. The date is one table with multiple columns like you suggested.