Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |