Countifs to filter if date = today()

[danny_tym]

Hi guys,

     Need your help with a newbie coming across from Excel.

     I need DAX to count if the entries were based on today.

     I've tried using Calculate along with Filter as I understand that's the alternative to Countifs so my DAX function were as follows:

    Would appreciate any help where I've gone wrong.

    I like to also create new measures based on the hour, for example, 8am - 9am, etc.

    Thanks in advance!

Cheers,

DT

[amitchandak · Accepted solution]

@danny_tym , Create a date without timestamp

example

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

Then it can work with today

or change filter like

filter(log, log[datetimeconerter] >=Today && log[datetimeconerter]  <today() +1 )

[danny_tym]

Thanks for the prompt response.

I added the extra column 'Date' through Power Query. 

Edit the formula and it turn up with this error:

Any help would be appreciated.

Thanks,