MAX Date with Filters

[kballar1]

 

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! 

[Dangar332 · Accepted solution]

hi, @kballar1 

try below

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

[kballar1]

This worked! Thank you! 

[Anonymous]

@Dangar332 

Would you know the answer to this please?