Create Measures based on Current Month

[Anonymous]

I have a bunch of measures e.g.

Appointments = DISTINCTCOUNT('Table'[Appointment ID])

And I want the measure to show only the current month data. So some sort of filter on TODAY() or something. 

Can this be done?

[Anonymous]

Hello, 

Yes, for exemple, if you want to show in a card, just put the measure in the card and drag the column that has the date to the filters area and on the filter data, choose the relative date and you can select "on this month"

Best Regards,

JO

[Anonymous]

I was hoping to be explicit within the measure rather than using the page filters

[Anonymous · Accepted solution]

IF (
        YEAR ( Table1[Create Date] ) = YEAR ( TODAY () )
            && MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )

 I hope this helps

Source: https://community.powerbi.com/t5/Desktop/Measure-for-Current-Month/td-p/91531

Best Regards,

JO