Skip to content

Instantly share code, notes, and snippets.

@PBI-DataVizzle

PBI-DataVizzle/last_working_day_v1.pq

Created March 20, 2024 05:29
Show Gist options
  • Save PBI-DataVizzle/da5e93546960762b648e974209d9cdf0 to your computer and use it in GitHub Desktop.
Save PBI-DataVizzle/da5e93546960762b648e974209d9cdf0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
last_working_day_v1.pq
List.Select(
List.Dates([EndOfMonth], Duration.From(- 1)),
each Date.DayOfWeek(_, Day.Monday) < 5
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment