Forum Discussion
Week Number as per months
Hi Data Naughts, I have a data set which has Date in it, I want to make a column which can show me a value like July-1st week, July-2nd week and so on. What I could do is take weeknum(Date) but i...
Please try this expression in a calculated column on your Date table.
Month Week = var weekstart = 'Date'[Date] - WEEKDAY('Date'[Date])
return FORMAT(weekstart, "MMMM") & " - Week " & ROUNDUP(Day(weekstart)/7,0)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat