CODEWITHSUNDEEP
powerbiconcatenation
redditor
redditor

Reputation: 4276

Concatenate rows based on user selection

I have a table like this:

Ticket Number Client Type
T123 Andy Question
T456 Bob Issue
T789 Charlie Problem

I use the filters to display which tickets I am interested in, then open Excel and use

= "www.myticket.url/" & TEXTJOIN("&",TRUE,A:A)

in order to open the url to display all my tickets (in this case, www.myticket.url/T123&T456&T789)

Is there a way to display this dynamically created URL directly in Power BI rather than having to download to Excel?

Upvotes: 0

Views: 244

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13450

You can create a measure using CONCATENATEX DAX function to concatenate the values in Ticket Number column, with & separator.

The measure could look like this (where Table is the name of the table):

URL = "http://www.myticket.url/" & CONCATENATEX('Table', [Ticket Number], "&")

Probably you will also want to set the data category of the measure to Web URL.

"www.myticket.url/"

Upvotes: 1

Related Questions