Weeknum for individual months RRS feed

  • General discussion

  • HI,

        I need formula for weeknum(power pivot) for generating weeknumber for individual months.

    Here is the example:

    date                                weeknum

    1/1/2013(jan)                     1

    -----                                2

    1/2/2013(feb)                    1

    -----------                       2

    But iam getting weeknum as sequence for whole year like 1,2,3,4.........52 weeknum  .please Provide the dax formula to work on this 

    Tuesday, May 7, 2013 6:54 AM

All replies