Forum Discussion

Lily_Lai346's avatar
Lily_Lai346
New Member
2 years ago
Solved

Dax Formula Help needed, Thanks!

Hi all, I have a data set that shows multiple forms downloaded by prospects, the fields used were created date/time, contact id and program names.  The data can show multiple lines of same contact i...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Lily_Lai346 , Based on what I got, check if this can help 

    Programme of Interest by Creation Date = 
CONCATENATEX(
    FILTER(
        SUMMARIZE(
            MFSA, 
            MFSA[Contact ID], 
            "EarliestDate", MIN(MFSA[Created Date/Time (FRA)]), 
            MFSA[Program Name]
        ),
        [EarliestDate] = CALCULATE(MIN(MFSA[Created Date/Time (FRA)]), ALLEXCEPT(MFSA, MFSA[Contact ID]))
    ),
    MFSA[Program Name],
    ", "
)
amitchandak's avatar
amitchandak
Super User
2 years ago

Lily_Lai346 , Based on what I got, check if this can help 

Programme of Interest by Creation Date = 
CONCATENATEX(
    FILTER(
        SUMMARIZE(
            MFSA, 
            MFSA[Contact ID], 
            "EarliestDate", MIN(MFSA[Created Date/Time (FRA)]), 
            MFSA[Program Name]
        ),
        [EarliestDate] = CALCULATE(MIN(MFSA[Created Date/Time (FRA)]), ALLEXCEPT(MFSA, MFSA[Contact ID]))
    ),
    MFSA[Program Name],
    ", "
)
Lily_Lai346's avatar
Lily_Lai346
New Member
2 years ago

Thanks so much Amit, it works!

 

Cheers,

Lily