Forum Discussion
Merging Columns using distinct ID number
Hey I have extracted the table below using the formular stated below, because I want to use the table as a visual; Active Ticket Table = CALCULATETABLE(Tickets,Tickets[[email protected]...
I used the response in this link and it worked
Solved: Re: Combining Rows based on the ID of that table - Power Platform Community (microsoft.com)
Anonymous add a measure for Request Type and then use this measure in the table visual along with other columns:
Request Type =
CONCATENATEX ( FILTER ( 'Table', 'Table'[StateCode] = "Active" ), [RequestType], ",")Thanks but this did not work. I would expect that the formula would use the ticket number as a distinct identifier to concatenate the Request Types. Please can you provide another formula