1 of 1 people found this helpful
Try creating an additional calculated field titled "Period prior to Max". Then use DATEADD("quarter", -1, [Max Period]. this is assuming you have made a calc for max period.
Let me know if that helps! Also, feel free to post some dummy data and I'll be able to help out more.
You may try filter the view like this
This worked. Thanks!!
Great! Please mark that answer as correct, for those in the future with the same problem.
A top filter can also be used to find the top two dates.