Solved: Re: Create Measures based on Current Month

Anonymous · ‎05-21-2019

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 · ‎05-21-2019

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

View solution in original post

Anonymous · ‎05-21-2019

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 · ‎05-21-2019

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

Anonymous · ‎05-21-2019

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