Skip to content

Instantly share code, notes, and snippets.

@SchreiberLars

SchreiberLars/fnGetISOCalendarWeekName.pq

Created May 30, 2018 15:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SchreiberLars/a081eb6ad063e758b3050683ae4678eb to your computer and use it in GitHub Desktop.
Save SchreiberLars/a081eb6ad063e758b3050683ae4678eb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fnGetISOCalendarWeekName.pq
(MyDate as date) =>
//Source --> https://blogs.office.com/en-us/2009/06/30/week-numbers-in-excel/
let
//MyDate = #date(2016,1,3),
Part1 = Number.From(MyDate) - Number.From(#date(Date.Year(Date.From(Number.From(MyDate) - (Date.DayOfWeek(Date.AddDays(MyDate,-1), Day.Sunday) + 1) + 4)),1,3)),
Part2 = Date.DayOfWeek(#date(Date.Year(Date.From(Number.From(MyDate) - (Date.DayOfWeek(Date.AddDays(MyDate,-1), Day.Sunday) +1) + 4)),1,3), Day.Sunday)+1 + 5,
ISOWeekNumber = "ISO KW "& Text.From(Number.IntegerDivide(Part1 + Part2, 7))
in
ISOWeekNumber
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment