Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Current Month to Date - Relative Date Filter

Is it possible to use the Relative Date Filter to reflect Current Month to Date? I am aware that it is able to reflect the past month but the goal is to just reflect current month to date. A measure was created that will correctly identify this but I plan on using a blank button to activate a bookmark which will trigger a table to filter to the Current Month to Date.
 
Expected output: Today = May 26, 2021 > Relative Date Filter = May 1, 2021 - May 26, 2021
 
Current output: Today = May 26, 2021 > Relative Date Filter (is in the last 1 month) = April 26, 2021 - May 26, 2021
 
Not sure if this matters but below is the current measure that I am using to for a KPI:

 

CALCULATE(
    TOTALMTD(
        COUNTROWS( Alerts ),
        Alerts[CreatedDate2] 
        )
)

 

Any advice on if this is possible will be greatly appreciated.
Need Help
Tutorial Requests
  • dkaushik's avatar
    dkaushik
    5 years ago

    Hi Anonymous 

    Yes, you can use the relative date option of the slcier and select "This", " ", "Month" . You will see current months values then.

     

     

1 Reply

  • dkaushik's avatar
    dkaushik
    Resolver II
    5 years ago

    Hi Anonymous 

    Yes, you can use the relative date option of the slcier and select "This", " ", "Month" . You will see current months values then.