How do I create a column containing the max number from a ranked column?

I'm creating an ETL and need to create a column that lists the highest value from another column that lists ranking. If it helps, the ranking is based on date created on. Something that looks like this:

 

Screen Shot 2019-05-20 at 2.52.23 PM.png

Best Answer

  • ST_-Superman-_
    Accepted Answer

    Because you are looking for the max value, I am going to recommend using the Group By tile.

    1.png

     

    2.png

     

    3.png

     

    4.png