Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Create Measures based on Current Month

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
7 years ago
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

3 Replies

Anonymous
Not applicable
7 years ago
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
  Not applicable
  7 years ago
  I was hoping to be explicit within the measure rather than using the page filters
  - Anonymous
    Not applicable
    7 years ago
    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

Related content