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