How To

[sshiny]

I need a solution, if the order count is 2 or more, I need to see the latest order date.

[Anonymous]

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

[amitchandak]

@sshiny , You can try approach I discussed here

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

[sshiny]

@amitchandak PFA the data sample. In the last order date , I need a single value-the last order date for the particular tag