Custom Column to retrieve the very first iteration of a Project name

[Deevo_]

Hi All,

Thanks in advance for your time.

What I am trying to do:

• I have a project which has gone through multiple name changes, but i need to retrieve the very first name that the project was given.
• I have tried to use MIN to calculate the earliest ID number, and then output the Project Name that is related to that ID number, but I am unable to repurpose other similar scenarios on this forum.

Sample Data:

ID	Project Name
001	Cloud enhancements
002	Cloud enhancements version 2
003	Cloud enhancements version 3

Expected result:

When i display the result in a table, I expect to see the project name "Cloud enhancements". This is the original name of the project.

thank you.

[Deevo_]

Thank you so much, this worked a treat. I modified your DAX slightly to pick the Earliest ID number instead of manually typing it in as I have multiple different projects.

I replaced "  'Table (2)'[ID] = 001 " with "MIN([ID])".

You have made my day !!!! Thanks once again

[Mahesh0016 · Accepted solution]

@Deevo_ I hope this hepls you!THANK YOU!!

ProjectName =

MAXX (

    FILTER (

        'Table (2)',

        'Table (2)'[ID] = 001

            && CONTAINSSTRING ( EARLIER ( 'Table (2)'[Project Name] ), 'Table (2)'[Project Name] )

    ),

  'Table (2)'[Project Name]

)

[Deevo_]

Hi Mahesh0016,

I have come to realise that replacing 'Table (2)'[ID] = 001 " with "MIN([ID])" does not work. I believe its because I have not specified in the DAX how to group the projects together. The piece of data missing from my Example is the "Project Code (Level 1 & ChangeID)" and the "Project Code Level 1".

The updated Sample date looks like this:

Sample Data:

Project Code (Level 1 & ChangeID)	Project Code Level 1	ChangeID	Project Name	Expected Result
P-1234-001	P-1234	001	Cloud enhancements	Cloud enhancements
P-1234-002	P-1234	002	Cloud enhancements version 2	Cloud enhancements
P-1234-003	P-1234	003	Cloud enhancements version 3	Cloud enhancements
P-4321-001	P-4321	001	Node Upgrade	Node Upgrade
P-4321-002	P-4321	002	Node Upgrade version 2	Node Upgrade
P-4321-003	P-4321	003	Node Upgrade version 3	Node Upgrade

Question:

Can you please help me to revise your DAX solution to Group by the "Project Code level 1" and then choose the "Project Name" of the earliest "ChangeID"?

Expected result:

1. P-1234 Project Name = Cloud Enhancements
2. P-4321 Project Name = Node Upgrade

Many thanks