topic Dax Measure for One date Dependent upon days calculation from another Date in DAX Commands and Tips

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

jeffr6596 — Fri, 03 Jan 2025 18:01:03 GMT

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 — Fri, 03 Jan 2025 21:12:08 GMT

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.