Combining Data

[amandabus21]

 I need help creating a column that integrates 2 columns. 

1 Incident ID has 3 cars (Car Number). 

The Order column dictates the order of the 3 cars numbers.

Im looking to create a column that has the Car Numbers with the correspoding Order. 

For example (4015-4048-4031)

[amitchandak]

@amandabus21 , There three ways to do.

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

In case of Power Query we can correct sorting using List.Sort

in DAx concatenatex provide sort option

[amandabus21]

Hi Amit, 

I tried following your video but didnt get the result I needed. 

My incident ID pulls from another table named Incident. 

Then that Incident ID goes into another table named Affected cars. Affected cars is where the Incident ID pulls the Car Numbers with the order. 

I need a table that gives me the Car Number in the correct Order, according to the corresponding primary key of Incident ID.