Forum Discussion
Numeric Filtering Fails on Some Values
I have a problem with filtering numeric values. I have a database table that defines a column as NUMERIC(18,1). I try to filter this column to only the value 9.3 and the created query rounds tha...
Have you tried custom SQL? That would ensure the query is sent to the database exactly as you define it.
I try to avoid custom SQL unless necessary for performance. I did get around this by recreating the process with a join rather than a more efficient buffered list / List.Contains option. Would have been easier to have Power BI handle numbers correctly....