Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

 

Please try this:

Column = FORMAT('Table'[Date],"mmmm")&" - "&WEEKNUM('Table'[Date],2)&" Week"