Forum Discussion

franorio's avatar
franorio
Icon for Helper III rankHelper III
9 years ago
Solved

Arg ZIP Code do not detected in map. IF formula or calculated column for Province?

Hello everybody,  this is some of the raw information my report has. Would like to create a MAP to see the subtotal of sales by region for Argentina. But Zip codes are not detected. The shipping Pr...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    franorio

    You can create a new DAX Column using SWITCH like this... Just add all other letters and their corresponding values :smileyhappy:

     

    Column =
SWITCH (
    'Table Name'[Province],
    "A", "Salta",
    "B", "Buenos Aires",
    "C", "Ciudad Autonoma",
    "Q", "Neuquen"
)

    Or in the Query Editor - Add column tab - Conditional Column

     

     

    Hope this helps! :smileyhappy: