topic Re: Filter that shows Next Month and Next 3 months in DAX Commands and Tips

Filter that shows Next Month and Next 3 months

Ttaylor9870 — Thu, 21 Sep 2023 14:54:18 GMT

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

Re: Filter that shows Next Month and Next 3 months

Anonymous — Tue, 26 Sep 2023 03:45:08 GMT

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

Re: Filter that shows Next Month and Next 3 months

lbendlin — Tue, 26 Sep 2023 12:52:19 GMT

Use the filter pane.