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:

     

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

Thanks Sean, 

About using the provinces, i need to create a new column with them, the ones i have in my report are letters..

A = Salta,

B = Buenos Aires

C = Ciudad Autonoma

...

Q = Neuquen...

 

would you please help me, with the formula to create the new calculated column to transform each letter in a State/Province?

 

Thanks!

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
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: