Help with Data Transformation/Clean up

[Anonymous]

I consider myself to have an advanced excel skill set, but I'm pretty fresh when it comes to working with PowerBI/PowerPivot.

I have some question regarding the best practice to clean up my columns of data. For example...

I'm doing a data export from an ERP into a csv file. In that export, some of the columns come in not how I would like such as this..

[Office]

Office : New York

Office : Florida

Office : California

So what I do is just import that csv as-is into PowerBI then use a calculated column formula logic to transform it into

[Office_Transformed]

New York

Florida

California

I have several other columns that have this issue. But this leaves me with double the columns I need on each table

So my question(s) is,

Is this something I should do within PowerBI?

Should I alter the csv before I upload?

Should I work with IT and figure out a way to alter the export on the ERP?

Thanks

[Hasan · Accepted solution]

I think that you can sue the Extract option in power query mode as "Extract Text Adter Delimiter: