Forum Discussion

kballar1's avatar
kballar1
Helper I
2 years ago
Solved

MAX Date with Filters

 

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! 

"DAX help"
DAX
Max
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, kballar1 

    try below

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

3 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, kballar1 

    try below

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