Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Count values excluding particular time

Hi,

 

How can I not count or Cancel Time between 00:00am to 06:00am? 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    Hi Anonymous,
    I am asuming your asking about a DAX logic to not count the rows b/w 00:00am to 06:00am. You can try with below logic.

    Cancel Count Daytime =
CALCULATE(COUNTROWS('TableName'),
    FILTER('TableName', HOUR('TableName'[Cancel Time]) >= 6)
)

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

1 Reply

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Super User
    1 year ago

    Hi Anonymous,
    I am asuming your asking about a DAX logic to not count the rows b/w 00:00am to 06:00am. You can try with below logic.

    Cancel Count Daytime =
CALCULATE(COUNTROWS('TableName'),
    FILTER('TableName', HOUR('TableName'[Cancel Time]) >= 6)
)

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.