Dax Measure for One date Dependent upon days calculation from another Date

[jeffr6596]

Hello,

I am new to the community and trying to decifer a way to write a dax measure to determine the following:

I have a "submitted date" and a "reviewed date"

I want to know if the item was reviewed within 10 days of the submitted date.

Can anyone help with writing the measure to find this outcome?

TIA

Jeff

[gmsamborn · Accepted solution]

Hi @jeffr6596 

It seems to me that since the durations between these dates don't change, a calculated column could be used.

Days = [Reviewed Date] - [Submitted Date]

Change the datatype to whole number.

Then add a measure as follows:

Reviewed Late = 
    COUNTROWS(
        FILTER(
            'Sheet1',
            'Sheet1'[Days] > 10
        )
    )

Let me know if you have any questions.

Check Review Date.pbix