Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Query Clarification

Hi,   I am having a few issues troubleshooting a DAX Query on the following.   I need to return a count value where by "ETA_Disch" is more then 7 Days old, & the "Recognized_WIP" is showing 0   ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous ,

     

    You can also try

     

    var _a = 'Table'[ETA_Disch]

    var _dd = DATEDIFF(_a,TODAY(),DAY)

    RETURN

    IF( _dd > 7 && 'Table'[Recognized_WIP] = 0,1,0)

     

    Regards,

    HN

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

 

var _a = MAX('Table'[ETA_Disch])

var _dd = DATEDIFF(Today(),_a,DAY)

RETURN

IF( _dd > 7 && 'Table'[Recognized_WIP]>1,1,0)

 

 

Regards,

Harsh Nathani

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Harsh,

 

Thanks for your help here.

 

Apologies for the delay, I instered the below query and it returnd a value but only 0 and no 1 counts.

 

Please see attached for your reviewScreen Shot

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Please create a Calculated Column

     

    var _a = 'Table'[ETA_Disch]

    var _dd = DATEDIFF(_a,TODAY(),DAY)

    RETURN

    IF( _dd > 7 && 'Table'[Recognized_WIP]>1,1,0)

     

    Regards,

    Harsh Nathani

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous ,

       

      You can also try

       

      var _a = 'Table'[ETA_Disch]

      var _dd = DATEDIFF(_a,TODAY(),DAY)

      RETURN

      IF( _dd > 7 && 'Table'[Recognized_WIP] = 0,1,0)

       

      Regards,

      HN