topic Re: HOW TO SHOW WEEKNUMBER PER PERIOD ? in DAX Commands and Tips

HOW TO SHOW WEEKNUMBER PER PERIOD ?

Anonymous — Fri, 10 Dec 2021 15:05:55 GMT

1 PERIOD CONTAION 4 WEEKS I NEED WEEKNUMBER TO RESET EACH PERIOD

THANKS

Anonymous — Fri, 10 Dec 2021 15:50:51 GMT

Hi,

Please try using below Dax

WeekNum = WEEKNUM('Table'[Period])

Anonymous — Fri, 10 Dec 2021 16:02:08 GMT

it works but i need week num to reset each period.

AlexisOlson — Fri, 10 Dec 2021 18:07:49 GMT

How about MOD ( WEEKNUM, 4 )?

Anonymous — Wed, 15 Dec 2021 07:11:26 GMT

Hi Anonymous ,

According to your description, you want to group by period and sort by week number.

Here's my solution.

Sample data.

Create a calculated column.

WeekNum = RANKX(FILTER('Table',[Period]=EARLIER('Table'[Period])),WEEKNUM([Date],2),,ASC,Dense)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sheelaaryal — Tue, 09 Apr 2024 15:43:11 GMT

This very helpful but would you be able to help with for some the periods the weeknum starts from 2 instead of 1