Filter that shows Next Month and Next 3 months

[Ttaylor9870]

Hey Experts, Good Afternoon!

I need to create a filter where I can select either next month and then next 3 months, for example...

Todays date is 21/09/2023 to next month should show Octobers data, Next 3 months should show October, November, December.

See example table below...

Name	Date
AA	21/10/2023
BB	21/11/2023
CC	21/12/2023
DD	25/11/2023

Many Thanks,

Taylor

[v-shex-msft · Accepted solution]

Hi @Ttaylor9870,

You can create a measure formula to use on 'visual level filter' to compare current row context date and system date to return flag, then you can use this flag as condition to filter correspond records based on current date.

flag =
VAR currDate =
    MAX ( Table[Date] )
VAR _endDate =
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 3, DAY ( TODAY () ) )
RETURN
    IF ( currDate >= TODAY () && currDate <= _endDate, "Y", "N" )

Applying a measure filter in Power BI - SQLBI

Regsards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

Use the filter pane.

[v-shex-msft · Accepted solution]

Hi @Ttaylor9870,

You can create a measure formula to use on 'visual level filter' to compare current row context date and system date to return flag, then you can use this flag as condition to filter correspond records based on current date.

flag =
VAR currDate =
    MAX ( Table[Date] )
VAR _endDate =
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 3, DAY ( TODAY () ) )
RETURN
    IF ( currDate >= TODAY () && currDate <= _endDate, "Y", "N" )

Applying a measure filter in Power BI - SQLBI

Regsards,

Xiaoxin Sheng