Power Query vs DAX - replace values

[Flexx]

Another noob question.

My source data is ugly and I end up doing a lot of "replace values" . For example, sometimes a person's name includes a middle initial, and sometimes the same name does not. So I end up making one match the other.

The question is , is it better to do this in power query or with dax once the data is loaded ?

thanks for the help.

[Flexx]

Thank you so much !

[v-easonf-msft · Accepted solution]

Hi, @Flexx 

It is generally recommended to clean data in PowerQuery, such as the replacement of some dirty data.

Dax is biased towards the summary and analysis of data. 

Power Query M vs DAX: Getting the Best of Both 

Best Regards,
Community Support Team _ Eason