Max Date To Current Date With Filtered Status

[Anonymous]

@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 · Accepted solution]

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.

[Dangar332]

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]

@Dangar332 

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