Forum Discussion
How do you exclude name columns due to inconsistent naming conventions
The database has consistent job numbers but the job names are not consistent. Each month as data was loaded, the job numbers remained the same (correct) but whoever loaded them put slighltly diffe...
jdbuchanan71
Super User
Super UserAnother option is to add a calculated column to your table, this one assumes there is a date of some kind to find the first instance of the name and use it.
Names Cleaned =
CALCULATE (
FIRSTNONBLANK ( 'Table'[name], MIN ( 'Table'[Date] ) ),
ALLEXCEPT ( 'Table', 'Table'[Job] )
)