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.
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?