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.
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 gettings empty/blanks and then i get errors for it. For instance i have 6.241 errors ( all the rows with blanks)
If i try to replace the blanks by 0 it doesn't work.
Thanks
Solved! Go to Solution.
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
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
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.