x Days after a date

[lewishyett]

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

[v-yulgu-msft · Accepted solution]

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