topic Re: Max Date To Current Date With Filtered Status in DAX Commands and Tips

Max Date To Current Date With Filtered Status

Anonymous — Thu, 11 Jan 2024 20:02:06 GMT

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.

Re: Max Date To Current Date With Filtered Status

Dangar332 — Thu, 11 Jan 2024 19:35:41 GMT

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

Re: Max Date To Current Date With Filtered Status

Anonymous — Thu, 11 Jan 2024 20:03:31 GMT

Dangar332

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

Re: Max Date To Current Date With Filtered Status

Anonymous — Mon, 15 Jan 2024 10:11:35 GMT

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.