Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Need some help here.
The default WEEKNUM function provides week number from the start of the year and runs 1 to 53 or 54.
If I need to show week number within the quarter, running 1 to 13 or 14 within each qtr, how should I do so?
I.e.
Thanks,
Solved! Go to Solution.
Try this, create 2 columns like this:
WeekNum = WEEKNUM([Date]) WeekOfQuarter = ROUNDUP(MOD([WeekNum],MAX([WeekNum])/4),0)
Try this, create 2 columns like this:
WeekNum = WEEKNUM([Date]) WeekOfQuarter = ROUNDUP(MOD([WeekNum],MAX([WeekNum])/4),0)
@Greg_Deckler I have try your method but the number doesn't look correct. Sharing the screenshot
I realise this is an old thread, but why does the calculation give me a week 0 for the 1st week of the quarter. Is there any way to rectify this. Great answer by the way.
It seems is working! Thank you! (I can't believe it was this simple haha)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |