topic Re: Combine values to one string with delimiter in DAX Commands and Tips

Combine values to one string with delimiter

PZU_DGW — Sat, 01 Aug 2020 15:21:08 GMT

My query has e.g. 3 values as a result, say 3 different names. How can I combine these names to 1 string with a delimiter between each name with DAX?

Greetings PZ

Re: Combine values to one string with delimiter

Fowmy — Sat, 01 Aug 2020 15:28:36 GMT

PZU_DGW

If you need to add a new column that combines the values from three columns using delimiter like "-", try:

= [Column1] & "-" & [Column2] & "-" & [Column3]

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

Re: Combine values to one string with delimiter

PZU_DGW — Sat, 01 Aug 2020 17:03:19 GMT

Thanks for your reply Fowmy.

The query-result is a result over 1 column and can be 1, 2 or sometimes 3 values. I like to combine these results to 1 string, with a constant delimiter, like "-", between every value.

Hope I explained it better 😉

Gr. PZU

Re: Combine values to one string with delimiter

Fowmy — Sat, 01 Aug 2020 17:06:15 GMT

PZU_DGW

Provide sample data, you can copy-paste here. do you need to do it in Power Query or DAX?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

Re: Combine values to one string with delimiter

Anonymous — Sat, 01 Aug 2020 18:28:59 GMT

PZU_DGW Can you share some sample data?

Re: Combine values to one string with delimiter

PZU_DGW — Sun, 02 Aug 2020 11:25:34 GMT

Sorry guys, I have only a printscreen, no code. As you kan see in de topright, you can select a contract. A contract contains 1,2 and sometimes 3 members/persons. When a contract is selected, the details show below. In this case 3 members (now only their partyID for security-resons insteat of their full names)

Finaly i like to show 1 string with the 3 PartyID's seperated with a delimiter.

Is it possible to upload the pbix-file?

Re: Combine values to one string with delimiter

Fowmy — Sun, 02 Aug 2020 11:38:49 GMT

PZU_DGW

Try this measure: You can drop it in a card visual.

PartyID String =

CONCATENATEX(

VALUES(Table[PARTYID]),Table[PARTYID],", ")

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

Re: Combine values to one string with delimiter

PZUDGW — Sun, 20 Sep 2020 18:26:58 GMT

Ok, due to vacancy and personal situation, I haven't been able to reply for a while.

The given answer is not completely satisfying. The string generated contains all partyID's, instead of the partyID's filtered by contract. This way, the generated string contains only the 3 - 2 or just 1 name(s) related to the contract.

Any suggestions?

Re: Combine values to one string with delimiter

Fowmy — Sun, 20 Sep 2020 18:48:59 GMT

PZUDGW

As per the screenshot that you have shared, I can see that there are three PartyIDs visible. The formula should return one string with those three PartyID when you select the contract H000033.

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

Re: Combine values to one string with delimiter

PZUDGW — Fri, 25 Sep 2020 20:37:01 GMT

Fowmy,

you can find the file here.

I'd like to have the description (of partyID's) at the end of each contract row.

Thanks for helping me!

Re: Combine values to one string with delimiter

PZUDGW — Sun, 04 Oct 2020 13:23:05 GMT

Problem solved. Sollution was realised by rearranging the relationsships between the datatables.