Forum Discussion

kattlees's avatar
kattlees
Icon for Post Patron rankPost Patron
5 years ago
Solved

Counting rows on a certain date

I need to get a count of the number of rows on a given day in a given month. My issue is when their arrival date or departure date is in a different month.   Example: Visitor                 arriv...
Need Help
Tutorial Requests
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

kattlees 

maybe you can try this

Measure = calculate(COUNTROWS('Table'),FILTER('Table','Table'[arrival]<=max('Date'[Date])&&'Table'[departure]>max('Date'[Date])))

pls see the attachment below