Master Name after creating distinct name table

[bcobrien77]

Hi,

I am trying to standardize names across various sources of data.  I created a propety name table to capture all of the distnict names that I need.

Property_Names = DISTINCT(UNION(VALUES(FinanceMonth[CostCenterName]),VALUES('All Things Units Matrix'[H1 Property Name])))

What I am hoping to do is take the output and be able to add a second column to the Property Name Table that would give me a master name and I cannot seem to do this efficiently in Power BI.

Do I need to export the property names to Excel and then make these adjustments?  I was hoping to make this dynamic and I know POWER BI must have a way of dealing with this.

Thanks

Property Names	Master Name
ASH	ASH Commons
ASH Commons	ASH Commons
First Street Complex	First Street Complex
1st St plex	First Street Complex
Royal Court Commons	Royal Court Commons
Royal CT.	Royal Court Commons

[v-juanli-msft]

Hi @bcobrien77 

We need to define a rule to select which value as the master name.

Do you have any match table or clear rule?

Best Regards

Maggie

[TomMartens]

Hey @bcobrien77 ,

if there is a business rule that can be put to DAX functions, then you can add the ADDCOLUMNS (https://dax.guide/addcolumns/) function around your table and create the Master Name column.

From a first look, it seems more simple to export the table and make the adjustments in Excel.

Regards,

Tom