Count for the entire current month (not just until today's date)

[peterso]

Hey folks,

First time posting on this awesome forum! I'm stumped with what should be a simple solution.

I'm trying to count the number of appointments for the entire current month. Using the MTD function counts until the current date, but I need a count for the entire month.

Thanks everyone!

[lbendlin]

Assuming you have a Dates table in your data model with a yearmonth column. If not then you should add that.

Full Month =

var m = selectedvalue(dates[yearmonth])

return Calculate (count(whatever),allselected(table),dates[yearmonth]=m)

That will give you the entire month, regardless of which day of that month is in focus.

[peterso]

I'm still getting an incorrect result. Maybe my formula is wrong?

Full Month = VAR m = SELECTEDVALUE('Date'[Month Year]) return CALCULATE(COUNT('Active Count'[Active Count Attribute]),ALLSELECTED('Active Count'[Active Count Attribute]), 'Date'[Month Year]=m)

[AntrikshSharma]

If you are slicing data by dates, months, and year, then at the month level you must already get the total of that month.