Forum Discussion

aileenc07's avatar
aileenc07
Frequent Visitor
4 years ago
Solved

HELP WITH FILTER PLEASE

Please help, why is there an error if loading and whenever i choose acs-discrepancy, nothing shows M_DISCREPANCY = switch(SELECTEDVALUE(INFRACTION[INFRACTION]), "ACS-DISCREPANCY",SU...
Need Help
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi aileenc07 ,

    Please click the View errors in the error message.

    Then in PowerQuery, an Errors in Table will appear.

    In the table, look through the error row, you will find the offending records.

    These errors are usually a data type mismatch. So you may have a situation where you have a value in a number data type column that can't be converted to number, or something similar.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi aileenc07 ,

Please click the View errors in the error message.

Then in PowerQuery, an Errors in Table will appear.

In the table, look through the error row, you will find the offending records.

These errors are usually a data type mismatch. So you may have a situation where you have a value in a number data type column that can't be converted to number, or something similar.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.