dynamic concatenate

[Controller_CVL]

I come here to ask for your help in a need for a project of mine, for that I'm going to put an example in the images of an excel spreadsheet but I want to do it in power bi, dax or m, what happens, I have some identifiers (Rfid) which shows me that all these destinations followed in the same vehicle, I need to concatenate the destinations in front of the lines as I painted in the example image, I have no idea how I would do it, and the order doesn't necessarily have to be from first throw to last , but it would be interesting if all the lines had the same value, thanks in advance for the help.

[Controller_CVL]

@NickolajJessen 

I didn't know about this function, I found it very interesting and apparently simple, however my code is giving a calculation memory error, I believe that the base is not so heavy that it could guide me on where possibly I am going wrong, I added the image below .

obs: Codigo, the value that should inform which lines should be concatenated

[NickolajJessen]

I notied than you are not using FILTER, ALL, MAX as in the provided example. Did this appreoach not work for you?

Are you able to share are .pbix through dropbox or your preferred sharing service?

[Controller_CVL]

Thank you very much, I did some more tests and ended up managing to solve it through your example.

[NickolajJessen · Accepted solution]

I answered a similar issue a while back. I hope you can adjust it to your data. Otherwise let me know.