Forum Discussion
Helper IIIArg ZIP Code do not detected in map. IF formula or calculated column for Province?
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:
Community ChampionTry plotting the Provinces' names with ArcGIS - seems to work there
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)
franorioThanks 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
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: