+ Reply to Thread
Results 1 to 7 of 7

ISO Calendar in Power Query

  1. #1
    Registered User
    Join Date
    04-24-2021
    Location
    Europa
    MS-Off Ver
    2019
    Posts
    5

    ISO Calendar in Power Query

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,536

    Re: ISO Calendar in Power Query

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-24-2021
    Location
    Europa
    MS-Off Ver
    2019
    Posts
    5

    Re: ISO Calendar in Power Query

    ok i got it :-) i changed it

  4. #4
    Registered User
    Join Date
    04-24-2021
    Location
    Europa
    MS-Off Ver
    2019
    Posts
    5

    Re: ISO Calendar in Power Query

    maybe I caught the wrong group. Wouldn't it be better to move the topic to the Excel General group? Many Thanks

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,536

    Re: ISO Calendar in Power Query

    I've moved it, however please be patient - it is the weekend, after all!!! Maybe you don't understand that this isn't a paid service?

  6. #6
    Registered User
    Join Date
    04-24-2021
    Location
    Europa
    MS-Off Ver
    2019
    Posts
    5

    Re: ISO Calendar in Power Query

    Thank you very much :-) Of course, I'm patient. I just thought that it might be in the wrong group. I know very well that it is not a paid service and that the experts work in their free time.

  7. #7
    Registered User
    Join Date
    04-24-2021
    Location
    Europa
    MS-Off Ver
    2019
    Posts
    5

    Re: ISO Calendar in Power Query

    I will wait patiently for that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query/Power Pivot Conditional Column creation & chart
    By mz_h in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2020, 06:07 PM
  2. [SOLVED] 2 fields checker- Request for alternative option in Power Query or Power Pivot
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2020, 08:36 AM
  3. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  4. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  5. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Replies: 0
    Last Post: 04-05-2018, 01:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1