Forum Discussion
akosiRandy
3 years agoFrequent Visitor
How to handle numeric null or blank values
I building a visual table where some values on some days has null or blank values. Please advise. Thanks in advance. Accepted = if(isblank(SUM(Chat_Snowflake[ACCEPTED Original])),0,SUM(Chat_S...
- 3 years ago
what exactly are you trying to do with the blank values?
It looks like maybe you want them to display as zeros?
Accepted = COALESCE(SUM(Chat_Snowflake[ACCEPTED Original]), 0)
//Mediocre Power BI Advice, but it's free//
kpost
3 years agoSolution Sage
what exactly are you trying to do with the blank values?
It looks like maybe you want them to display as zeros?
Accepted = COALESCE(SUM(Chat_Snowflake[ACCEPTED Original]), 0)
//Mediocre Power BI Advice, but it's free//
akosiRandy
3 years agoFrequent Visitor