Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
I hope you are doing well
I would like to know how can i create a week column (like 1st week, 2nd week, 3th week and 4th week) based on a date column
or like this, to be more close to your expectation:
WeekNum = “Week”&WEEKNUM([Date],2)
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 17 | |
| 10 | |
| 7 | |
| 6 |