Forum Discussion
Switch in modified date
I have this list: This table is about testing. When a test is one, it is good. When it is two, it is bad. Every month there will come a new value for some rows (not every row). It depends on w...
lbendlin
Super User
Super UserI think you have bigger problems. Your data structure is not sustainable. You will want to unpivot your data and bring it into a form like
Item | Date | Result
Then it is trivial to use TOPN(1) or MAX() to find the latest result for each item.