Forum Discussion
Solved
Finding the most recent value change
Requirement: Create a custom column that lists the most recent updated start date. Background: PSOW # is always required. PCR # is only used if there are ammendments to orginal PSOW #. PCR # alw...
I wasn't following your description, but purely by looking at your expected result I suspect you can acheive this easily in the query editor.
You can "Group By" PSOW# and add two aggregations: SUM of Cost and MAX of Start Date. See if that works. I'm not 100% sure about the MAX of Start Date but try it and let us know
parry2k
Super User
Super UserMAX function works with dates, so in this it will be ok.
If I use Max or LastNonBlank how do I ensure my table is sorted properly where it always evaluates the highest number PCR # all the way down to the blank PCR #? For code example I'll use lastnonblank. Basically I need to sort by PCR # before returning LastNonBlank.
Current Start Date =
LASTNONBLANK ( PSOW[Est Start date], 1 )