Forum Discussion
Concatenate lines
I have a table in an Oracle database that stores several lines that refers to only one line in another table. I would like to know if there is a way to transform this lines in one unique line. ...
Tahreem24
Super User
Super UserAnonymous ,
Try below DAX to get your requirement:
Column = CONCATENATE(Sheet1[Amount],LOOKUPVALUE(Sheet2[Amount],Sheet2[Name],Sheet1[Name]))
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
Tahreem24Super User
Super UserAnonymous , In my above post my key column is Name. So accordingly create your DAX.
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.