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...
Hi Anonymous ,
You can achieve it using below steps in Power Query:
1. From 'Date' column, create a 'Name of Month' column
2. From 'Date' column, create a 'Week of Month' column
3. Add a conditional column with below cases:
Note: Week of Month here is the column created/added in step 2
4. Merge 'Name of Month'(created in Step 1) and 'Custom'(Created in Step 3) with custom seperator hyphen/dash(-)
5. Optional Step: Remove 'Week of Month'(created in Step 2)
Final Result:
If this post solved your query, mark this post as solution and give a thumbs up !!!