I have the following table. There are 8 machine ID's. What I need is a table which shows the color of the maximum last status date/time. So for machine 1 this is the color red, for machine 2 color red, machine 3 color orange...etc. I tried selected value and lookup value together with maximum last status date / time, but don't get the right solution. Please advise! Thanks in advance.
to be very honest, this is the solution I use in similar cases. I understand is convoluted and maybe there are better solution, so if anyone has better ideas, I am looking forward to.
One important caveat: TOPN returns multiple rows if there is a tie (i.e. if there are more than one row with the same "top" last date). So it would be better to protect yourself from future occurences of this situation by either including in another TOPN or using SUMMARIZE or other functions that returns just one row.
Filtered on machine ID so that I have 4 rows. After that I can't implement the TopN into the visual (because it is a date?). Formula does not work. Can you be more specific to the solution? Thanks in advance!!