locked
Week of Month RRS feed

  • Question

  • Is there a DAX function to get the week of the month from a date field?
    MSDNStudent Knows not much!
    Monday, December 5, 2011 4:04 PM

Answers

  • Hi Try this formula =WEEKNUM([TSTDATE],2)-WEEKNUM([TSTDATE]-DAY([TSTDATE])-6,2)
    Eddy N.
    • Marked as answer by MSDN Student Thursday, December 8, 2011 6:47 AM
    Tuesday, December 6, 2011 9:32 AM