Calculate custom week number

[CosminB]

Hi all,

I'm trying to create a custom week number (period week) using ideally import date (A) or import week (B).

The numeration of period week should be calculated based on the custom Start date and End date. These two columns are not available in my data model.

In quarter info I have only the start date of the week 1 and the end date which correspond with week 6.

= Table.AddColumn(#"Expanded quarter_info", "Period Week", each Text.Start([Quarter],4) & " wk" & Number.ToText(Date.WeekOfYear([Import Date]) - Date.WeekOfYear([quarter_info.Start Date) + 1))

This code it's calculating the end of week 1 on Friday and the start of the week 2 on Monday:

I tried also to create in the datamodel a table with the dates for each week (week 1 - week 6) but it's affecting the values displayed on every visual (there are sales numbers).

Any suggestion will be appreciated.

Thanks

[Anonymous]

Hi @CosminB ,

I'm sorry I didn't understand what you meant. Can you provide relevant example data or a pbix file without private data and show the expected results you want to accomplish?
I apologize that I did not succeed in understanding your request and would appreciate it if you could explain it clearly for me.

Best regards,

Community Support Team Selina zhu

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