Want week Number from 1 for those months also where week starting from saturday or sunday.

[jay_patel]

Hi experts

Here is my graph as you can see in attached picture and selected month year is 'MAY-2021' where week 1 started from saturday so they dont have sales in week 1, however I want to consider from week 1 only. In the second screenshot you can see I am extracting WEEK NO from Transaction date, So is there any way where i can consider week 2 as week 1 and so on for the months that dont have sales in 1st week.

Thanks & Regards

[v-kelly-msft · Accepted solution]

Hi @jay_patel ,

Create a column with dax expression as below:

Adjusted week no = 
var _firstday=STARTOFMONTH('Table'[Date])
var _weekday=WEEKDAY(_firstday,2)
Return
IF(_weekday=6||_weekday=7,
  IF('Table'[Week month]=1,BLANK(),"Week"&('Table'[Week month]-1)),
   "Week"&'Table'[Week month])

Then you would see:(Remember to modify the data type of "Week month" to whole number)

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!