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
Proud to be a Super User! |  |
Try equals null (lower case) for the condition, or put in a Replace Values step before it that replaces null with 0
Proud to be a Super User! | |
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
