Forum Discussion

antholee's avatar
antholee
New Member
6 years ago
Solved

Finding Latest Date in Already Filtered Table

Hello, I am looking for help with this:   How would I find the latest date from an already-filtered table? e.g. from a table of a few thousand rows, I have filtered out 2 rows: how could I ...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi antholee , 

    I think you need to use measure to achieve this goal. You could refer to my sample for details.

     

    Best Regards,
    Zoe Zhi

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

antholee's avatar
antholee
New Member
6 years ago

Sorry if it was not clear.

I am filtering a table using the date already. In my case, I am filtering for August 4th 2020. After filtering, I am left with 2 rows, in which I want to create another column that will signify the row that occurs at a later time (Last Updated MST). I would like a calculated column that will identify that 8/4/2020 11 20 AM occurs after 11:10AM .

 

I have tried your recommendation and it returned to me the same two dates.

dax's avatar
dax
Community Support
6 years ago

Hi antholee , 

I think you need to use measure to achieve this goal. You could refer to my sample for details.

 

Best Regards,
Zoe Zhi

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