Home Forums Power Pivot Year Month with Week Number

This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 2 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #4069

    [email protected]
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    I have a formula =[YearMonth]&” Week: “&WEEKNUM([Date]) to identify the year, month, and week number. But when weeks overlap to 2 different months, it will show 10/31/2013 as ‘2013 Oct Week 44’, and 11/1/2013 as ‘2013 Nov Week 44’. When months overlap, is there an earlier function or some other function to include to keep it consistent? If week number of this row is same as last, use the year/month/week number of previous row, otherwise use year/month/week number of this row.

    Sample of what I would normally do in excel is attached. Looking how to do this in a powerpivot window calculated column instead.

    #4087

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2552
    • Total: 2559

    If your calendar (dates) table had columns for week start, week ending, week number you could just concatenate three into a combined column.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.