topic Re: DAX Measure to create a 4 Week Period in DAX Commands and Tips

DAX Measure to create a 4 Week Period

Pradnya_Haraple — Wed, 05 Apr 2023 15:53:18 GMT

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?

vicky_ — Wed, 05 Apr 2023 22:11:20 GMT

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

Pradnya_Haraple — Tue, 11 Apr 2023 13:29:46 GMT

Yes, this worked for me.

Thanks for your help