Forum Discussion

kballar1's avatar
kballar1
Icon for Helper I rankHelper 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Dangar332 

     

    Would you know the answer to this please?

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident 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)