Forum Discussion

3 Replies

    • sshiny's avatar
      sshiny
      Helper II
      4 years ago

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

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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