Forum Discussion
Blanks vs Zero's when utilizing an Excel Doc as a Datasource
as sayaliredij said, you can fix them on the Power BI side instead using "DIVIDE" like this:
New Column = DIVIDE([Value A], [Value B], <put 0 or BLANK() here depending on what you want in error case>)
In my opinion, though, as far as Power BI is concerned, whether you do it in Excel or Power BI, best practice is to fill with zeros. It is more likely to result in desired behavior in the visuals you end up creating using that data set.
as sayaliredij said, you can fix them on the Power BI side instead using "DIVIDE" like this:
New Column = DIVIDE([Value A], [Value B], <put 0 or BLANK() here depending on what you want in error case>)
In my opinion, though, as far as Power BI is concerned, whether you do it in Excel or Power BI, best practice is to fill with zeros. It is more likely to result in desired behavior in the visuals you end up creating using that data set.
Sounds good. I'll roll with the zeros then. Appreciate it!