Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |