ISO WEEK of Year in power query

Sami Chahed 0 Reputation points
2023-05-24T14:57:04.8633333+00:00

How can we get week of Year in ISO in Power Query

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
    2023-05-25T09:11:51.8966667+00:00

    Hi,

    I suggest you follow this article about how to create ISO Week and year in Power Query:

    https://gorilla.bi/power-query/create-iso-week-and-iso-year/

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments