Forum Discussion

Pradnya_Haraple's avatar
Pradnya_Haraple
Frequent Visitor
3 years ago
Solved

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. 

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?

 

Need Help -DAX Measures
  • vicky_'s avatar
    vicky_
    3 years ago

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

2 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

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