Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the following Conditional Column looking for the count of occurrences of a CQ prefix.
The Quote No column can also have prefixes of BOQ or DQ. So when I refresh my table, I return many thousands of errors for the fields that contain BOQ or DQ. Can anyone advise of an amendment to make to the custom column formula that would ignore DQ/BOQ and stop the errors?
Thank you.
Solved! Go to Solution.
Thanks for coming back to me. Closer inspection revealed the errors where because there were blank values in the column which were being treated as null values which was causing the error. Replaced null with blanks and problem solved.
Probably should have investigated a bit more before I post here!
Thanks for coming back to me. Closer inspection revealed the errors where because there were blank values in the column which were being treated as null values which was causing the error. Replaced null with blanks and problem solved.
Probably should have investigated a bit more before I post here!
Can you provide some sample data and explain more clearly what the problem is?
The code is looking for "CQ" and doesn't refer to BOQ or DQ. What errors are you receiving?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.