Current Month to Date - Relative Date Filter

[Anonymous]

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.

[dkaushik · Accepted solution]

Hi @Anonymous 

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