Hello everyone, I have a CSV file from the exchange. I would like to update this every week. The format output (see the Power Query file) should have a year column, a quarter column, a month column and a calendar week column. However, only the US calendar week is output in Power Query. In the week of the year column there is already calendar week 2 (highlighted in yellow) from January 4th, although it is calendar week 1 in Germany. Can someone help me to enter the ISO date that applies to Germany in the calendar week? Unfortunately, the Iso function is not yet available in Excel Power Query.
Many Thanks
Bookmarks