Multiple Filetype in a column from a Source - Can M handle such?

[ovetteabejuela]

I have some data sources that have some multiple data-types. These are excel workbooks, some sources are coming from templates which have in the formula =if(a+b=0,"No Sales",a+b).

What usually happens is that I have to go over and remove these "No Sales" occurences - BUT is there some way that during import process (in PowerBI) this can be handled? I'm thinking M, but how (if it is able).

Or what could you suggest - I could go ask that the formula be changed but I am curious now if there is a way to handle such situations.

[MattAllington · Accepted solution]

When you are importing data (get data) you can select the column and select "replace value" to replace this text with either null or 0

[ovetteabejuela]

---

@MattAllington wrote:

When you are importing data (get data) you can select the column and select "replace value" to replace this text with either null or 0

---

@MattAllington, That I should try, thanks.

By the way I just purchased "The Definitive Guide to DAX", great book but I am also planning to get yours within the month.