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 ...
Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0
Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0
Works like magic!! Thanks man!!