Allow using Dictionaries in PowerQuery for mapping data
As a user I would like in Power Query to be able to map/translate/tranform data based on some defined dictionary.
For example: in source data I have a column "Subcategory" with many combinations. And in some xls file I have mapped those subcategories on new segments.
There are a lot of combinations (more than 200) so I cannot do it with conditional column. I my opinion quick way to solve this would be by extending "Add condtional column" functionality and add a possibility to load an dictionary from xls in a predefined format.