Week of the month

[Anonymous]

I want to show weeks of the month, but each new week need to start with monday.
This is the following example I want to reproduce.



I tried to do this :
weekinmonth = 1 + WEEKNUM ( TableName[Date],2 ) - WEEKNUM ( STARTOFMONTH ( TableName[Date] ),2 )

=> But in my case, I have duplicated dates so it doesn' work

Thanks for help

[v-yuta-msft]

@Anonymous ,

You can remove the duplicate date firstly in power query by clicking Remove Rows-> Remove Duplicates.

 

Community Support Team _ Jimmy Tao

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

[Anonymous]

By removing duplicates, I will loose data from other columns