Forum Discussion

exodeexo's avatar
exodeexo
New Member
8 years ago
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...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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])
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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])
exodeexo's avatar
exodeexo
New Member
8 years ago

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!!!!

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Happy to help :)