Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
4 years ago

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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    amandabus21
    Icon for Helper V rankHelper V
    4 years ago

    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.