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 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

 

 

 

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 )

2 Replies

  • 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,