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])
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!!!!
Happy to help :)
This came in very handy for me today. Thanks for working through this in great detail 2 years ago!
