John

Gladly work on

It can be done but I would need to see your workbook (Packaged workbooks and flows: when, why, how ) - but it is a complex viz

Jim

Hi John

What - very complex workbook - I am not tracking with you on how you can tell a contract has been extended - I am seeing only "End Date" as dimension and I don't see any flag that would indicate an extension or that the date has been changed -  How can you see an extension?

Jim

John I think I have an approach for you but I am having difficulty with the different date formats here in the US

I will walk you through the approach and you can try it and see what it does

The idea here is to use a fixed max and fixed min end date for each unique opportunit

fixed max =          {FIXED [Consultant],[Opportunity Ref], [Candidate]:max([End Date])}         

(note I used the 3 dimensions only out of ignorance - if 1 will do then just use that)

fixed min =          { FIXED [Consultant], [Candidate]:min([End Date])}

And the check =

          if ATTR([fixed max end date])>WINDOW_MAX(max([End Date]))

          and attr([fixed max end date])<>ATTR([fixed min end date])

           then "red" end

things to note -

The Window_Max(Max([end_date]) is to get the max date from your filter

this is a table calculation and it must be set to DOWN

Next you put this on color tile and then edit the color tile as shown

Now it will color the VALUES - red when the condition of the extended date is met

Now here is the problem I keep running into

this is a print of part of a check screen I have been using - the column marked 1 is the Max end date for the permutation created by the formula above

the column marked 2 is the actual date in the sheet -  There are 2 rows with the values shown in Red indicating they meet the criteria but if you look at the 2 columns noted above you will see the calculated max date is in 2018 and in no way matches the actual date - I checked to see if there were other records for the permutation but could find none (maybe hidden in the data somewhere?

all the other dates seem to match up OK

That's where I am on this You should be able to add the check and max min dates and highlight the values - but I have not been able to test the data fully

Let me know

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Thanks John

I wondered if it was what you needed - your workbook is so complex it was difficult to tell

Jim