Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Controller_CVL
Frequent Visitor

dynamic concatenate

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_0-1655904398838.png

 

1 ACCEPTED SOLUTION
NickolajJessen
Solution Sage
Solution Sage

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

NickolajJessen_0-1655904783957.png

 

View solution in original post

4 REPLIES 4
Controller_CVL
Frequent Visitor

@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 .

 

 

Controller_CVL_0-1655991075063.png

 

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

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?

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

NickolajJessen
Solution Sage
Solution Sage

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

NickolajJessen_0-1655904783957.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors