DOT Separator in SPOT column
What happens when web scrapping and the conversion rates come without the dot separator? For example, USD shows at 10538. The problem here is that there is no pattern among the numbers, so I can't really convert them all at once into their correct decimal values
are you using the same url?
Absolutely!
https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
This is how it is presented
I figured it might have something to do with the region settings. I gave a quick look into someways of changing it and I couldn't figure out however how to change it when loading data from web. I did found a solution, however for when loading it from CSV file, as described in:
https://community.powerbi.com/t5/Desktop/Problem-to-import-the-dot-from-a-column/m-p/205396