Results 1 to 7 of 7

ISO Calendar in Power Query

Threaded View

  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

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