Forum Discussion
Solved
Change Type not converting to number anymore
Hi all, hope someone can help. We didn't use to have this problem but it suddenly occurs now. We have exchange rates coming in as text and they don't convert to numbers anymore. Our settings ...
Hi Ruta,
The settings that you have referenced are for DAX formulas, nothing to do with Power Query.
PQ formats are governed by the Regional settings. Go to File > Options & Settings > Options and check your setup here:
...and here:
Note that you will have to close down Power BI Desktop and restart it for Regional Settings changes to take effect.
Pete
BA_Pete
Super User
Super UserHi Ruta,
The settings that you have referenced are for DAX formulas, nothing to do with Power Query.
PQ formats are governed by the Regional settings. Go to File > Options & Settings > Options and check your setup here:
...and here:
Note that you will have to close down Power BI Desktop and restart it for Regional Settings changes to take effect.
Pete
Thanks, Pete, this works now!