Calculated column for blank in Power Query

[Anonymous]

Hello, 

I add a calculated column to power query (M) just to bucket the Agents score per month, how many times they got <89% or >=90% to 97% and >=98% per day on a whole month. The thing is, if the Quality Score column is blank the calculated column returns a Error. (Reference at the picture below). Since my datasource is connected to the sharepoint (which the Quality Team update on everyday basis). Everytime i refresh this error occurs.

I tried to = to blank and turns the answer to 0 but it doesnt accept blank as entry.

Appreciate your reply thanks!

[ToddChitt · Accepted solution]

Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0

[Anonymous]

Works like magic!! Thanks man!!