Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I have a problem to convert whole number to date. The numbers are like this: yyyymmweek
How can I do??
Solved! Go to 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.
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |