Forum Discussion
Calculated column for blank in Power Query
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!
Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0
2 Replies
Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0