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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Pradnya_Haraple
Frequent Visitor

DAX Measure to create a 4 Week Period

Need a help on DAX Measure to create a period based on Week Number.

I want to combine 4 weeks into one period. 

Pradnya_Haraple_0-1680709536829.png

For example :

If Week Number is  1, 2, 3, 3 then a measure should display a period value as 1,

If Week Number is 4, 5, 6, 7 then it should display a period value as 2.

Can this be done with the help of DAX?

 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

I think you can do something like:
4 Week Period Number = QUOTIENT(WeekNumber, 4)

View solution in original post

2 REPLIES 2
vicky_
Super User
Super User

I think you can do something like:
4 Week Period Number = QUOTIENT(WeekNumber, 4)

Yes, this worked for me.

Thanks for your help

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.