How to count dates less than or equal to and more than two separate date columns using a calendar.

[Anonymous]

Afternoon,

I am trying to count wether a note was created on a certain day. In Excel you can click the cell with the date but in PowerBi this is not possible.

Is there a measure that could provide if the [Entry Date] <= MIN calendar date and the [Date Complete] > MIN calendar date?

Any solutions are welcome.

Regards,

Sam

[Fowmy]

@Anonymous 

You can use Filter function for this:

Count Measure = 
COUNTROWS(
FILTER(
    'Table',
    'Table'[Entry] <= min(CALENDAR[date]) && 'Table'[Date Complete] > min(CALENDAR[date])
    )
)

[Fowmy]

@Anonymous 

If the provided solution works for you, please click on "Accept as Solution" so that others will find it useful.