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

 

The current EXCEL foruma ustilised is =IF(AND(TODAY()-BS15>7,BB15>1),1,0)

 

Attached SS for review.

 

Thanks in adance for any assistance.

 

 

 

  • 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

4 Replies

  • 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