Whole number in to yyyy,mm,w

[Bergh]

Hi I have a problem to convert whole number to date. The numbers are like this: yyyymmweek

How can I do??

 

[MattAllington]

Well, if you had yyyymmdd i would say go into power query, split the column into 3, yyyy, Mm, dd and then merge again in the format dd-mm-yyyy. Then convert to a date. But I have no idea how to turn your week number into a date. I guess you will need to do it in Excel manually. 

[v-yuta-msft · Accepted solution]

@Bergh ,

As Matt mentioned, the we can't determine the day in a week, so you can only convert the number to date(Year/Month) and week seperately.

Besides spliting the column, you can also create custom columns using M code below:

YearMonth = Text.Start(Text.From([Date]), 4) & "/" & Text.Middle(Text.From([Date]), 4, 2)

Week = Text.End(Text.From([Date]), 1)

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.