Forum Discussion

Lily_Lai346's avatar
Lily_Lai346
New Member
2 years ago
Solved

Dax help needed Again

Hi There, I would like to improvise on below formula, the desired result is to have below: Contact id -  Program Name ( concatenated in a string by contact id, in ascending order of creation date o...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Lily_Lai346 ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Test =
CONCATENATEX(
    FILTER(ALL('MFSA'),
    'MFSA'[Contact id]=EARLIER('MFSA'[Contact id])&&'MFSA'[Created Date/Time (FRA)]<=EARLIER('MFSA'[Created Date/Time (FRA)])),[Program Name],",")

    2. Result:

    If it doesn't meet your expected results, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

amitchandak's avatar
amitchandak
Super User
2 years ago

Lily_Lai346 , Create a measure below and use with id column

Measure = CONCATENATEX(SUMMARIZE('MFSA',,MFSA[Created Date/Time (FRA)],MFSA[Program Name]),[Program Name],",",MFSA[Created Date/Time (FRA)])