Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to Solution.
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! | |
Works like magic!! Thanks man!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |