Forum Discussion

barakm's avatar
barakm
Frequent Visitor
2 years ago
Solved

Converting week and years in M code

Dear Team,I'm new to Power BI, trying to figure out the issue. I have a column named "Period Week" with data looks like 23.2024  means the 23th week of the year 2024  I wish to convert it a regular...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    and try this code in power query

     

    [
    parts = Text.Split([Week Year], "."),
    weekNum = Number.FromText(parts{0}),
    yearNum = Number.FromText(parts{1}),
    startOfYear = #date(yearNum, 1, 1),
    dayOfWeek = Date.DayOfWeek(startOfYear, Day.Sunday),
    daysOffset = if dayOfWeek = 1 then 0 else 7 - dayOfWeek,
    firstSunday = Date.AddDays(startOfYear, daysOffset),
    weekStartDate = Date.AddDays(firstSunday, (weekNum - 1) * 7)
]
    [weekStartDate]

     

Ahmedx's avatar
Ahmedx
Super User
2 years ago

and try this code in power query

 

[
    parts = Text.Split([Week Year], "."),
    weekNum = Number.FromText(parts{0}),
    yearNum = Number.FromText(parts{1}),
    startOfYear = #date(yearNum, 1, 1),
    dayOfWeek = Date.DayOfWeek(startOfYear, Day.Sunday),
    daysOffset = if dayOfWeek = 1 then 0 else 7 - dayOfWeek,
    firstSunday = Date.AddDays(startOfYear, daysOffset),
    weekStartDate = Date.AddDays(firstSunday, (weekNum - 1) * 7)
]
    [weekStartDate]