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'm creating a new column by adding values of five other columns together, but where there are null values, the new column also returns a numm value - can you suggest how I can fix this please?
Thanks
Solved! Go to Solution.
Thank you for your reply. I've managed to make it work by replacing all the numms with zeros.
Hi, @GMonk55 ;
Null values indicate an empty cell or the absence of any data.
And in that sense, you can’t really call null a value. While zero is an actual value, null is the absence of a value.
You could replace null values by 0, use error checking or make use of the List.Sum formula.here i tested the List.Sum formula.
The final show:
3 Ways to SUM null values in Power Query M - BI Gorilla
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @GMonk55 ;
Null values indicate an empty cell or the absence of any data.
And in that sense, you can’t really call null a value. While zero is an actual value, null is the absence of a value.
You could replace null values by 0, use error checking or make use of the List.Sum formula.here i tested the List.Sum formula.
The final show:
3 Ways to SUM null values in Power Query M - BI Gorilla
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. I've managed to make it work by replacing all the numms with zeros.
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.
User | Count |
---|---|
107 | |
93 | |
77 | |
64 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |