Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
malguera
Frequent Visitor

Need help creating "Week of Quarter"

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.

 

WeekOfQtr.PNG

 

Thanks,

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

Try this, create 2 columns like this:

 

WeekNum = WEEKNUM([Date])

WeekOfQuarter = ROUNDUP(MOD([WeekNum],MAX([WeekNum])/4),0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

Try this, create 2 columns like this:

 

WeekNum = WEEKNUM([Date])

WeekOfQuarter = ROUNDUP(MOD([WeekNum],MAX([WeekNum])/4),0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler  I have try your method but the number doesn't look correct. Sharing the screenshot error1.pngCapture.expected.PNG

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)

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors