Forum Discussion
M Query filter on Value.FromText
Your code is working fine with me and I can load the table without any issues.
Can you eloborate on "it fails": don't you get the desired results? Or what error message do you get?
Not sure what the error is exactly. I insert the line to filter, Close and Apply, then this:
Try to view the error, but there doesn't seem to be any info:
I backtrack through the query steps of the error table to where there is data, and supposed errors, but the columns all appear clean to me. I've seen errors in other queries/projects with the little orange Error word.
Strangely, I can just close the error popup and the accounts seem to be filtered, but then my measures and visuals break.
The measure that supposedly has the error does use Account Number, but not in the SUM portion. Very strange stuff....