Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
win_anthony
Resolver III
Resolver III

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.
1 ACCEPTED SOLUTION
dkaushik
Resolver II
Resolver II

Hi @win_anthony 

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

 

 

View solution in original post

1 REPLY 1
dkaushik
Resolver II
Resolver II

Hi @win_anthony 

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

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors