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(Fin...
Need Help
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