Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Anonymous
Not applicable

โ€Ž07-24-2022 09:00 PM
Just found the solution by indirect way and it works
 
Count = COUNTROWS(
FILTER(EventTable,
AND(EventTable[Location]="TW",
AND(EventTable[Open date]<Dates[Dates],
IF(EventTable[Close date]>0,
EventTable[Close date]>Dates[Dates],
1)
)
)
)
)

View solution in original post

2,173 Views