Forum Discussion
max date conditional
HI exodeexo
Please try this calculated column
New Column = MAXX( FILTER( 'Sequencer', 'Sequencer'[Process] IN {"PHTS","PHTM"} && 'Sequencer'[Campaign ID] = EARLIER('Sequencer'[Campaign ID]) ), 'Sequencer'[Start Sequence])
Excuse me Phil_Seamark!
I made a mistake, the two first rows should be 13/10/2015 if the campaign id is equals 136411. I've forgotten to change the campaign ID in the two first rows.
Cool, I nearly have it. Just one more question.
On that same campaign 136411, how come all the dates are the 13th, except for the last one which is the 14th of Oct?
HI exodeexo
Please try this calculated column
New Column = MAXX( FILTER( 'Sequencer', 'Sequencer'[Process] IN {"PHTS","PHTM"} && 'Sequencer'[Campaign ID] = EARLIER('Sequencer'[Campaign ID]) ), 'Sequencer'[Start Sequence])You are a genius,Phil_Seamark!
It works!!! You save me a lot of time!!! Because I've spent all my day trying to solve it!
Many thanks!!!!
Sorry Phil_Seamark. It was another mistake that I've modified. The expected result for campaign ID 136411 is 14/10/2015.
The correct table:
Area Process Start Sequence Campaign ID MAX_DATE WH COD 29/07/2015 155555 null WH PREP 30/07/2015 155555 null WH PREP 30/07/2015 135871 null PRODUCT DESC_IT 28/08/2015 135871 null WH PREP 30/07/2015 136411 14/10/2015 PRODUCT DESC_IT 19/08/2015 136411 14/10/2015 PHOTO PHTM 13/10/2015 136411 14/10/2015 PHOTO PHTS 14/10/2015 136411 14/10/2015 WH PREP 19/10/2015 127861 23/10/2015 PHOTO PHTM 23/10/2015 127861 23/10/2015 RETOUCH BR24 14/10/2015 127861 23/10/2015 RETOUCH PROD 14/10/2015 127861 23/10/2015 PHOTO PHTS 13/10/2015 127861 23/10/2015 PRODUCT DESC_IT 21/10/2015 127861 23/10/2015 PRODUCT UPDATA_IT 15/10/2015 127861 23/10/2015 PRODUCT UPDATA_IT 19/10/2015 127861 23/10/2015 PHOTO PHTM 21/10/2015 127861 23/10/2015
Excuse me Phil_Seamark
The correct table is:
Area Process Start Sequence Campaign ID MAX_DATE WH COD 29/07/2015 155555 null WH PREP 30/07/2015 155555 null WH PREP 30/07/2015 135871 null PRODUCT DESC_IT 28/08/2015 135871 null WH PREP 30/07/2015 136411 14/10/2015 PRODUCT DESC_IT 19/08/2015 136411 14/10/2015 PHOTO PHTM 13/10/2015 136411 14/10/2015 PHOTO PHTS 14/10/2015 136411 14/10/2015 WH PREP 19/10/2015 127861 23/10/2015 PHOTO PHTM 23/10/2015 127861 23/10/2015 RETOUCH BR24 14/10/2015 127861 23/10/2015 RETOUCH PROD 14/10/2015 127861 23/10/2015 PHOTO PHTS 13/10/2015 127861 23/10/2015 PRODUCT DESC_IT 21/10/2015 127861 23/10/2015 PRODUCT UPDATA_IT 15/10/2015 127861 23/10/2015 PRODUCT UPDATA_IT 19/10/2015 127861 23/10/2015 PHOTO PHTM 21/10/2015 127861 23/10/2015