I have the following table in PowerPivot. I'd like to create a column ("Show") that will have the name of the quarter corresponding to the highest rank for all rows with the same ID. The table below shows the desired end state where "Show" is the calculated column I'm after:

[![enter image description here](https://i.stack.imgur.com/B3JcV.jpg)](https://i.stack.imgur.com/B3JcV.jpg)