topic Re: MAX Date with Filters in DAX Commands and Tips

MAX Date with Filters

kballar1 — Thu, 11 Jan 2024 15:40:02 GMT

I have physical date and workflow status. I am needing the latest "physical date" to todays date with the workflow status not including "received pricing".

How many days between the max "physical date" to todays date not including the workflow status "received pricing."

Please advise. Thank you!

Re: MAX Date with Filters

Anonymous — Thu, 11 Jan 2024 18:40:14 GMT

Dangar332

Would you know the answer to this please?

Re: MAX Date with Filters

Dangar332 — Thu, 11 Jan 2024 18:53:33 GMT

hi, kballar1

try below

measure = var a = maxx( filter( tablename, tablename[workflow status]<>"received pricing" ), tablename[physiacal date] ) return datediff(a,today(),day)

Re: MAX Date with Filters

kballar1 — Thu, 11 Jan 2024 20:06:32 GMT

This worked! Thank you!