Forum Discussion

Preetsingh86's avatar
Preetsingh86
Regular Visitor
1 year ago
Solved

Calculate Week Number

Hi, I am trying to calculate financial week number for the dates column. Our financial year starts from Sept - Aug, and our first day of work is Sunday. I have tried DAX measure WEEKNUM but not sure ...
  • BeaBF's avatar
    BeaBF
    1 year ago

    Preetsingh86 Hi! Try to adapt this new calculated column to your data:

     

    Financial Year =
    IF(
    MONTH([Date]) >= 9,
    YEAR([Date]),
    YEAR([Date]) - 1
    )

    Financial Week Number =
    VAR StartOfYear =
    DATE([Financial Year], 9, 1)

    VAR WeekNumber =
    WEEKNUM([Date] - StartOfYear + 1, 11)
    RETURN
    WeekNumber

     

    BBF

BeaBF's avatar
BeaBF
Super User
1 year ago

Preetsingh86 Hi! Try to adapt this new calculated column to your data:

 

Financial Year =
IF(
MONTH([Date]) >= 9,
YEAR([Date]),
YEAR([Date]) - 1
)

Financial Week Number =
VAR StartOfYear =
DATE([Financial Year], 9, 1)

VAR WeekNumber =
WEEKNUM([Date] - StartOfYear + 1, 11)
RETURN
WeekNumber

 

BBF

  • Preetsingh86's avatar
    Preetsingh86
    Regular Visitor
    1 year ago

    It worked, thank you ğŸ˜€