Forum Discussion
Solved
COUNTROWS that match a certain value (date)
Good Morning, I'm really struggling with this one in DAX as it'd be so simple with Excel. Bascially, I have been sent a dataset with the due date of a project formatted in yyyy-mm: ...
As a shortened form of the other answer, you can use :
Count of due dates this month = COUNTROWS(FILTER(TableName, TableName[Target Date Month(If known)]= FORMAT(TODAY(),"YYYY-MM")))
As a shortened form of the other answer, you can use :
Count of due dates this month =
COUNTROWS(FILTER(TableName, TableName[Target Date Month(If known)]= FORMAT(TODAY(),"YYYY-MM")))