Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
franorio
Helper III
Helper III

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 Provinces are downloaded by letter, for example Province Buenos Aires is letter B, Ciudad Autonoma letter C, Neuquen letter Q. 

 

shipping zip.PNG

 

How should I do to create a measure or calculated column to say if:

 

A = Salta

B = Buenos Aires

C = Ciudad Autonoma

...

Q = Neuquen

Z = Santa Cruz

 

Want to try if Power BI detects Argentinian provinces. But would prefer to detect by ZIP for more precision. Any ideas?

 

Thanks & Regards

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@franorio

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

 

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

 

QE - Conditional Column.png

 

Hope this helps! Smiley Happy

 

View solution in original post

3 REPLIES 3
Sean
Community Champion
Community Champion

Try plotting the Provinces' names with ArcGIS - seems to work there

 

Argentina.png

 

I can see they don't plot all correctly in PBI

I suspect some of those Province names may have to be adjusted to plot correctly in the native PBI maps

Look at my response here (similar but in Spain)

http://community.powerbi.com/t5/Desktop/Filled-map-error-on-Province-Zaragoza-amp-gt-puts-in-Mexico/...

 

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
Community Champion
Community Champion

@franorio

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

 

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

 

QE - Conditional Column.png

 

Hope this helps! Smiley Happy

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.