HOW TO SHOW WEEKNUMBER PER PERIOD ?

[Anonymous]

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

THANKS

[v-stephen-msft · Accepted solution]

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]

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

[pratnappagol12]

 Hi,

Please try using below Dax

WeekNum = WEEKNUM('Table'[Period])

[Anonymous]

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

[AlexisOlson]

How about MOD ( WEEKNUM, 4 )?