Pull text data from one column, based on multiple criteria

Using the "Main Table" as the source, I am trying to create a measure that will generate what is shown in the "Table w/ Measure".   What I need is a measure that determines the latest audit date fo...