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
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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?

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Happy to help :)

  • davidataylor's avatar
    davidataylor
    Frequent Visitor
    6 years ago

    This came in very handy for me today.  Thanks for working through this in great detail 2 years ago!