How To

Hi  sshiny

Is this result what you want?

This is the original data:

After I apply the measure( if the order count is 2 or more, appear the latest order date):

If it is what you want, you can try this measure:

maxdate = var _max= MAXX(ALL('Table'[order date]),'Table'[order date])

return IF(SELECTEDVALUE('Table'[order counts])>=2, _max,SELECTEDVALUE('Table'[order date]))

 

Here is my test file that you can use to help understand

Best regards,

Community Support Team Selina zhu

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