I am pretty new to using power query and i am struggling a bit with some data i am trying to transform.
Currently i am receiving some .csv files on a monthly basis where i have managed to transform most of the data to be as accurate as possible. However i am struggling with formatting the date and time from US to european layout.
When i try to transform this using locale to Swedish it changes it to 9th of january 2022. When in fact the date is 1st of september 2022. The time isn't really of importance.
What i would like in the long run is to from this create a new custom column with only the month displayed.
Hopefully someone out there has a solution to my question, thanks a lot.