Forum Discussion

danny_tym's avatar
danny_tym
Frequent Visitor
4 years ago
Solved

Countifs to filter if date = today()

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 a...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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 )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
danny_tym
Frequent Visitor
4 years ago

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,