90 day filter

[arunquist]

I am new to powerbi and not terribly filmilar with the columns vs. measures and formulas.  my issue is that I am looking to create a filter for rolling 90 day period.  Any help is appreciated I am stumpped...

EX: If column 1 = Event type then filter column 2 >90 days

[v-yulgu-msft]

Hi @arunquist,

Suppose your data table is like below:

To filter the fisrt table and get the second table, you should create a new table using formula as :

New Table =
CALCULATETABLE (
    '90 day filter',
    FILTER (
        '90 day filter',
        ( '90 day filter'[Column1] = "Event"
            && '90 day filter'[Column2] > 90 )
            || '90 day filter'[Column1] <> "Event"
    )
)

If I have something misunderstood, please share your sample data and provide more detailed description about your requirement, like a image of your expect result.

Thanks,
Yuliana Gu