Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Max Date To Current Date With Filtered Status

Dangar332 

I have physical date, Price Approved Date and workflow status. I am needing the MAX "physical date", "Price Approved Date" with the workflow status not including "received pricing". 

How many days between the max "physical date" to 'Price Approved Date" not including the workflow status "received pricing."

 

Please advise. Thank you! 

 

I tried this code but got an error: 

 
var statusG=SELECTEDVALUE(cr93f_cpsoo[Workflow Status])
return
if(statusG="-Received Pricing",DATEDIFF(MAX(SELECTEDVALUE(cr93f_cpsoo[Physical Date]),SELECTEDVALUE(cr93f_cpsoo[PriceApproved.date]),DAY)))
 
Error: Too many arguments were passed to the MAX function. The maximum argument count for the function is 2.
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

     

    This dax function error occurs because you have added two fields to the Max() function.

    You can use the following dax:

    Measure =
IF(
    MAX('cr93f_cpsoo'[Workflow.Status])="-Received Pricing",
    DATEDIFF(
        MAX('cr93f_cpsoo'[Physical Date]),MAX('cr93f_cpsoo'[PriceApproved.date]),DAY))

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, Anonymous 

    can you clear your requirnment becuase 
    one you mention MAX "physical date" to "Price Approved Date"  and "physical date" to todays date with condition

    not including "received pricing" .

     

    and in above code you did not mention TOADY() date in entire code so i'm little confuse here

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Dangar332 

       

      I apologize. It is Max "Physical Date" to "Price Approved Date" not including the status from workflow status "-Received Pricing" in Days.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    This dax function error occurs because you have added two fields to the Max() function.

    You can use the following dax:

    Measure =
IF(
    MAX('cr93f_cpsoo'[Workflow.Status])="-Received Pricing",
    DATEDIFF(
        MAX('cr93f_cpsoo'[Physical Date]),MAX('cr93f_cpsoo'[PriceApproved.date]),DAY))

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.