Forum Discussion
Solved
Power BI Week NO
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
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
1 Reply
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