Forum Discussion

lewishyett's avatar
lewishyett
New Member
7 years ago
Solved

x Days after a date

Hi,

 

I have a table called change_requsst. This table contains two fields "change_state" and "status_change_date".

 

I would like a Measure which counts how many change_requst are

 

1) change_state = "C - Qualified - To Be Scoped and Quoted"

2) the todays date is 3 days after the "status_change_date"

 

Please could someone advise.

 

Thanks

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi lewishyett ,

     

    Please refer to this measure:

    count =
CALCULATE (
    COUNT ( change_requsst[change_state] ),
    FILTER (
        ALLSELECTED ( change_requsst ),
        change_requsst[change_state] = "C - Qualified - To Be Scoped and Quoted"
            && DATEDIFF ( change_requsst[status_change_date], TODAY (), DAY ) = 3
    )
)

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi lewishyett ,

     

    Please refer to this measure:

    count =
CALCULATE (
    COUNT ( change_requsst[change_state] ),
    FILTER (
        ALLSELECTED ( change_requsst ),
        change_requsst[change_state] = "C - Qualified - To Be Scoped and Quoted"
            && DATEDIFF ( change_requsst[status_change_date], TODAY (), DAY ) = 3
    )
)

    Best regards,

    Yuliana Gu