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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.