Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Filtering - +2 months from current date without including all months in between

Hi There,    I have 3 pages where each of the pages should show only the specific values for "this month", "next month", "+2 month". Example for this month: Page 1: Shows only values for May 20...
Date
relative date filtering
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    Hi Anonymous,

     

    You may try this solution.

    1 Create a Measure

    DateIn+2Month =
VAR CurrentMon =
    MONTH ( TODAY () )
VAR ExpectedMon = CurrentMon + 2
RETURN
    CALCULATE (
        COUNT ( 'Table'[MS110(B)] ),
        FILTER ( 'Table', MONTH ( 'Table'[MS110(B)] ) = ExpectedMon )
    )

     

    2 Use this Measure as a visual filter, then only data for July will be displayed in the visual

     

    Also, attach the sample pbix as reference.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous,

 

You may try this solution.

1 Create a Measure

DateIn+2Month =
VAR CurrentMon =
    MONTH ( TODAY () )
VAR ExpectedMon = CurrentMon + 2
RETURN
    CALCULATE (
        COUNT ( 'Table'[MS110(B)] ),
        FILTER ( 'Table', MONTH ( 'Table'[MS110(B)] ) = ExpectedMon )
    )

 

2 Use this Measure as a visual filter, then only data for July will be displayed in the visual

 

Also, attach the sample pbix as reference.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

EvanGetsItDone's avatar
EvanGetsItDone
Icon for Helper I rankHelper I
2 years ago

There is gonna be an issue to this. What if current month is November 2023, the future 2nd month should be January 2024 right? 

what should we do to involve the Year in the calculation? Thanks!