topic Combining Data in DAX Commands and Tips

Combining Data

amandabus21 — Wed, 10 Aug 2022 17:10:37 GMT

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 — Thu, 11 Aug 2022 05:03:06 GMT

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 — Thu, 11 Aug 2022 16:53:07 GMT

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.