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]]="Active")
As seen in the table there are duplicate data in the Value.TicketNumber, ProjectName & StatusCode, which I could have used remove duplicate data to remove. However, the RequestType column has distinct request Types.
| Value.TicketNumber | ProjectName | RequestType | StatusCode | StateCode |
| 2023-IDM-0000001 | Phone Case | Builder's linen | Pending Assignment | Active |
| 2023-IDM-0000002 | Project Spinoff | W&D of ODRW | Awaiting Documents | Active |
| 2023-IDM-0000003 | DRW-0128YNS | Coperate Search | Merging | Active |
| 2023-IDM-0000003 | DRW-0128YNS | Easement Access | Merging | Active |
| 2023-IDM-0000003 | DRW-0128YNS | Builder's linen | Merging | Active |
| 2023-IDM-0000004 | YU-Jason Project | Easement Access | Pending Assignment | Active |
| 2023-IDM-0000005 | MP-927-2023 | Encroachment | Awaiting Documents | Active |
| 2023-IDM-0000006 | 719-YUGNT-2022 | Builder's linen | Merging | Active |
| 2023-IDM-0000007 | 2023-Builders Project | City-to-City General | Awaiting Documents | Active |
| 2023-IDM-0000007 | 2023-Builders Project | Encroachment | Awaiting Documents | Active |
| 2023-IDM-0000008 | Aspen Woods Project 2021 | Ground Tie | Merging | Active |
| 2023-IDM-0000008 | Aspen Woods Project 2021 | City-to-City General | Merging | Active |
| 2023-IDM-0000009 | Alpine Grounding | Builder's linen | Pending Assignment | Active |
| 2023-IDM-0000010 | Brent Jdrainage | Encroachment | Pending Assignment | Active |
| 2023-IDM-0000011 | Ground Opening Project | W&D of ODRW | Pending Assignment | Active |
| 2023-IDM-0000012 | City-to-City Drone | W&D of ODRW | Merging | Active |
| 2023-IDM-0000012 | City-to-City Drone | Coperate Search | Merging | Active |
| 2023-IDM-0000012 | City-to-City Drone | Easement Access | Merging | Active |
Whih formula can i use to make the Active intakes table appear as seen below please either in the visual or in the table
| Value.TicketNumber | ProjectName | RequestType | StatusCode | StateCode |
| 2023-IDM-0000001 | Phone Case | Builder's linen | Pending Assignment | Active |
| 2023-IDM-0000002 | Project Spinoff | W&D of ODRW | Awaiting Documents | Active |
| 2023-IDM-0000003 | DRW-0128YNS | Coperate Search, Easement Access, Builder's linen | Merging | Active |
| 2023-IDM-0000004 | YU-Jason Project | Easement Access | Pending Assignment | Active |
| 2023-IDM-0000005 | MP-927-2023 | Encroachment | Awaiting Documents | Active |
| 2023-IDM-0000006 | 719-YUGNT-2022 | Builder's linen | Merging | Active |
| 2023-IDM-0000007 | 2023-Builders Project | City-to-City General, Encroachment | Awaiting Documents | Active |
| 2023-IDM-0000008 | Aspen Woods Project 2021 | Ground Tie, City-to-City General | Merging | Active |
| 2023-IDM-0000009 | Alpine Grounding | Builder's linen | Pending Assignment | Active |
| 2023-IDM-0000010 | Brent Jdrainage | Encroachment | Pending Assignment | Active |
| 2023-IDM-0000011 | Ground Opening Project | W&D of ODRW | Pending Assignment | Active |
| 2023-IDM-0000012 | City-to-City Drone | W&D of ODRW, Coperate Search, Easement Access | Merging | Active |
Thank you in advance for your help
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)
4 Replies
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], ",")Anonymous your reply didn't help? How I will know what is not working? Are you getting the wrong result or blank or error? How I expect to provide the answer without knowing what is not working?
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)
