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.