Forum Discussion
Solved
0 that appear as blanks
Hi, I have a stock report that is using the following formula for a column called "count": =Table.AddColumn(#"Add Gender_Cat","count", each if [stock] >= 1 then 1 else 0) Instead of getting 0 i am...
Hi Pamoa
1. Try changing the nulls fro zeroes (or an other value you need) before this step.
2. Otherwise account for the null in the formula for the custom column, for instance:
Table.AddColumn(#"Add Gender_Cat","count", each if [stock]=null then null else if [stock] >= 1 then 1 else 0)Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
AlB
Community Champion
Community ChampionHi Pamoa
1. Try changing the nulls fro zeroes (or an other value you need) before this step.
2. Otherwise account for the null in the formula for the custom column, for instance:
Table.AddColumn(#"Add Gender_Cat","count", each if [stock]=null then null else if [stock] >= 1 then 1 else 0)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers