cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovetteabejuela
Impactful Individual
Impactful Individual

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.

 

 

1 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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

2 REPLIES 2

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post


@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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.