Forum Discussion

sgodfrey's avatar
sgodfrey
Frequent Visitor
7 years ago
Solved

compare a date field to a defined date

Hi,   I'm trying to count the number of rows where a certain date/time field has been met according to a statically defined date in DAX as the visual filter will not work with the particular viz I ...
  • sgodfrey's avatar
    sgodfrey
    7 years ago

    Thanks, still double-checking the results and math, but its definitely evaluating both the date and the time now!  :)

SteveCampbell's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
7 years ago

Hello,

 

Usually, it is good to use DATE() and TIME() functions for comparison.

 

Can you try:

PWDGT06152018_Enabled =
CALCULATE (
    DISTINCTCOUNT ( Table[acctname] ),
    FILTER (
        'Table',
        'Table'[AcctType] = "Value"
            && 'Table'[EnabledDisabled] = "Enabled"
            && 'Table'[passwordChange].[Date]
                >= DATE ( 2018, 06, 15 ) + TIME ( 14, 30, 0 )
    )
)
  • sgodfrey's avatar
    sgodfrey
    Frequent Visitor
    7 years ago

    Thanks, still double-checking the results and math, but its definitely evaluating both the date and the time now!  :)