Create column with first occuring value in existing column

[Holmje]

Hi!

I have a issue that i can not resolve and having a hard time finding a matching solution. Im new to dax and powerbi but will give it a try to formulate what the issue is

I have multiple cars and mutiple manufacturers from which the cars picks up goods, each pickup generates data in the form of a row in my dataset. Each car can pickup goods from different manufacturers at different times of the day, these get logged as a pickup from each respective manufacturer but what i want to do is create a manipulated column for all rows containing just the first manufacturer for each car and day.

Would appreciate the help

Regards

[amitchandak]

Right-click on the measure in visualization property and check Aggregation is Not Summarized 

[Holmje]

Hi, thank you for your reply.

It might be that i am to much of a rookie to understand how that is going to solve the problem as i need to use the "manipulated" column to create a new measure of number of deliveries made by each car for every given day but visualized depending on which manufacturer the first pickup was made from

Regards

[Holmje]

Just to clarify, the "car" column contains a cars unique identification number