Forum Discussion
Solved
max date conditional
Hi guys!! I'd like to create a column (called "MAX_DATE") where I identify the max date in two specific process (PHTM & PHTS) per campaign. If these processes doesn't exist in the campaign, I'd l...
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])
Hi exodeexo
Happy to help. Can you please post what your expected result would look like for this sample dataset?
This will help clarify your request :)
Hi Phil_Seamark!! Thanks for helping me.
My expected result for this sample is the last column on your right.
MAX DATE null null null null 13/10/2015 13/10/2015 13/10/2015 14/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 23/10/2015 Many thanks!
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.
