Forum Discussion
Multiple Filetype in a column from a Source - Can M handle such?
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.
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
2 Replies
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 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.
