Skip to content

Instantly share code, notes, and snippets.

@PBI-DataVizzle

PBI-DataVizzle/last_working_day_v2.pq

Created March 20, 2024 05:30
Show Gist options
  • Save PBI-DataVizzle/5d4f1f4c7e54fc995885e26cedf8d2eb to your computer and use it in GitHub Desktop.
Save PBI-DataVizzle/5d4f1f4c7e54fc995885e26cedf8d2eb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
last_working_day_v2.pq
Table.AddColumn(GetDates, "Last Working Date", each
Date.AddDays(Date.EndOfMonth([Date]),
List.Min({0, 4 - Date.DayOfWeek(Date.EndOfMonth([Date]),
Day.Monday)})))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment