Forum Discussion
Combining Data
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)
2 Replies
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
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.
