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

 

Happy to help.  Can you please post what your expected result would look like for this sample dataset?

 

This will help clarify your request :)