Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Replace repetitive string with one string

Hi Everyone, I have a column with the click flow of a user on a specific day:  ClickFlowColumn = CALCULATE(CONCATENATEX(ActivitiesTable, ActivitiesTable[ActivityType], ", "), ALLEXCEPT(Activ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    What do you change your formula like this?

    ClickFlowColumn =
CALCULATE (
    CONCATENATEX (
        VALUES ( ActivitiesTable[Activity Type] ),
        ActivitiesTable[Activity Type],
        ", "
    ),
    ALLEXCEPT ( ActivitiesTable, ActivitiesTable[UserId], ActivitiesTable[Date] )
)

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
have you tried use the contcatenex function?
CONCATENATEX(VALUES(Table1[Column1]),[Column1])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi vanessafvg 

     

    That worked!

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      Anonymous 

      What do you change your formula like this?

      ClickFlowColumn =
CALCULATE (
    CONCATENATEX (
        VALUES ( ActivitiesTable[Activity Type] ),
        ActivitiesTable[Activity Type],
        ", "
    ),
    ALLEXCEPT ( ActivitiesTable, ActivitiesTable[UserId], ActivitiesTable[Date] )
)

       

      ________________________

      If my answer was helpful, please consider Accept it as the solution to help the other members find it

      Click on the Thumbs-Up icon if you like this reply 🙂

      YouTube  LinkedIn

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Fowmy  That worked! Thank you!