When used in combination with "each" in the second argument, Table.ReplaceValue kills all existing column types (sets them back to any). Please fix: https://social.technet.microsoft.com/Forums/en...
The same problem happens whenever I create a new column with each as second argument.
This is particularly problematic in Direct Query scenarios where the operation of transforming the column back to the original data type is not supported. The solution, so far, doesn't help me at all.