Weeknum

determine the week number of a given date in the year.

The WeekNum() function in Power FX is used to determine the week number of a given date in the year.

It allows you to track what week a date falls into, which is useful for reporting, scheduling, and other time-based calculations.

Syntax

WeekNum(ThisItem.DateColumn, StartOfWeek.[Weekday])
  • ThisItem.Date: A column contains the date data for which you want to determine the week number.

  • StartOfWeek.[Weekday]: Specifies which day of the week to treat as the start day.

By default, it treats Sunday as the first day of the week. But you can use the StartOfWeek enumeration:

Examples

Last updated