Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Master Name after creating distinct name table

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 NamesMaster Name
ASHASH Commons
ASH CommonsASH Commons
First Street ComplexFirst Street Complex
1st St plexFirst Street Complex
Royal Court CommonsRoyal Court Commons
Royal CT.Royal Court Commons
Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    Hey Anonymous ,

     

    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

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    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