I have a product that changes price periodically. I need to be able to flag the latest price. I have the State, Area and Gender along with implementation date and price. I use a combination of State, Area, and Gender to get a Aggr Key and then use an Aggr function in a calculated dimension to get the Max Date. All this seems to work. All I have to do now is flag where the Imp Date matches the Max Date. I just cannot get this to work. I have tried as dates, numbers and text. I just cannot get dates to match. I have searched and Googled and spent many hours on this. I just cannot figure it out. Any ideas. Attached is a sample qvw.
