Skip to content

Instantly share code, notes, and snippets.

@bjulius

bjulius/gist:bd3ec8f41c69982a74165cf70430aa04

Last active March 15, 2024 10:27
Show Gist options
  • Save bjulius/bd3ec8f41c69982a74165cf70430aa04 to your computer and use it in GitHub Desktop.
Save bjulius/bd3ec8f41c69982a74165cf70430aa04 to your computer and use it in GitHub Desktop.
Download ZIP
Solution to Oz Du Soleil Excel PQ Challenge March 10 2024
Raw
gistfile1.txt
let
Source2 = Table.FromList(List.Numbers(2013, 11), Splitter.SplitByNothing(), {"Year"}, null, ExtraValues.Error),
AddDay = Table.SelectRows( Table.AddColumn(Source2, "DayOfWeek", each Date.DayOfWeekName( #date( [Year], 10, 14))), each [DayOfWeek] = "Monday"),
Answer = List.Max(AddDay[Year])
in
Answer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment