Forum Discussion
we cannot replace value null to type text
Hi Anonymous
Did a test and replacing null in a column that is type number with zero works fine. The formula looks like this Table.ReplaceValue(#"PreviousStep",null,0,Replacer.ReplaceValue,{"Number"})
Try converting your number column to type text first, do a replace and convert it back to number after. Alternatively, you may create a custom column with a formula similar to this if [Column] = null then 0 else [Column] and then delete the original column
thanks, I tried both of these approached and neither worked.
Anonymous , Are you able to attached your pbix with the data source?
I don't think I can share the data.
the problem occurs as soon as I pivot
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Status]), "Status", "Count")
If I extract the data to a CSV and perform the same series of steps it works fine. but not on my OData source.
Anonymous that's interesting. You should open a support ticket. I hardly uses/had a chance to use ODAta so cannot help much but this seems to be a bug that it works with one type of data but not other. good luck and post your solution here so that it can help others.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
