Forum Discussion
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. ...
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
I was hoping to be explicit within the measure rather than using the page filters
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