Forum Discussion
Enter a data validation in a Power BI or Power Query query
my suggestion is that you do a merge in power query with your list that you want to validate against the list that has the valid numbers using an anti join to pull back all the non matching values which dont match.
more explanation here.
http://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
in terms of your list for correcting the numbers, how many correct values do you have, this part is probably going to be more complicated depending on how much data you have, i guess you would need to find where the smallest difference is between the invalid number and a valid number but how to do that exactly , not sure maybe someone else can assist there.
Community Championmy suggestion is that you do a merge in power query with your list that you want to validate against the list that has the valid numbers using an anti join to pull back all the non matching values which dont match.
more explanation here.
http://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
in terms of your list for correcting the numbers, how many correct values do you have, this part is probably going to be more complicated depending on how much data you have, i guess you would need to find where the smallest difference is between the invalid number and a valid number but how to do that exactly , not sure maybe someone else can assist there.
Hello Vanessafvg,
Thanks you very much for your explanation.
Best regards.