Fridays 13/01/2023 17/02/2023 17/03/2023 14/04/2023 12/05/2023 16/06/2023 14/07/2023 18/08/2023 15/09/2023 13/10/2023 17/11/2023 15/12/2023
Code:// Query1 let Source = List.Dates(#date(2023, 01, 01), 366, #duration(1, 0, 0, 0)), C2T = Table.FromList(Source, Splitter.SplitByNothing(), type table[Date = Date.Type], null, ExtraValues.Error), DayN = Table.AddColumn(C2T, "Day Name", each Date.DayOfWeekName([Date]), type text), Friday = Table.SelectRows(DayN, each ([Day Name] = "Friday")), DayNum = Table.AddColumn(Friday, "Day", each Date.Day([Date]), Int64.Type), Range = Table.SelectRows(DayNum, each [Day] >= 12 and [Day] <= 18), Ren = Table.RenameColumns(Range,{{"Date", "Fridays"}}), TSC = Table.SelectColumns(Ren,{"Fridays"}) in TSC




Bookmarks