Power BI Week NO

[suresh123]

Derar Team,

My company Financial year July to June. I have the stock report with Stock Date. I want to add the Week Num in the stock Date based on Stock Take Date.  I used formula Weeknum([date],1).

 Weeknumber comes as per Calendar Date. This is First sunday of calendar year as WK1.

I want first sunday of the JUly month should be WK1. Any DAX Formulas for this?

Suresh

[v-qiuyu-msft · Accepted solution]

Hi @suresh123,

You can create a calculated column like below: 

FiscalWeek = IF(WEEKNUM('DateTable'[Date],1)>=WEEKNUM(DATE(YEAR('DateTable'[Date]),7,1)),WEEKNUM('DateTable'[Date],1)-26,WEEKNUM('DateTable'[Date],1)+26)

Best Regards,
Qiuyun Yu