Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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)