Forum Discussion

MorePowerBI's avatar
MorePowerBI
Icon for Helper II rankHelper II
5 years ago

Question about WEEKNUM

I'm using 

WEEKNUM(TODAY(),1)-1
to obtain the week number of the previous week, but if today was the first week of the year would this formula return a 0? or will it return 52?
 

1 Reply

  • rfigtree's avatar
    rfigtree
    Icon for Resolver III rankResolver III
    5 years ago

    Would this work.

    WEEKNUM(TODAY()-7,1)

    Because you will get 0 when it is week 1.