topic Week Number from Specific (Static) date in DAX Commands and Tips

Week Number from Specific (Static) date

msommerf — Mon, 25 Apr 2022 12:34:45 GMT

Hi, I am looking to create a column in my date table which shows week numbers that start from 6th April every year as per example below:

Can anyone advise?

amitchandak — Mon, 25 Apr 2022 17:02:34 GMT

Start Year = if(format([Date], "MMDD")*1 < 406 , date(year([Date])-1,4,6) ,date(year([Date]),4,6) )

FY Week num = QUOTIENT(datediff([Start Year], [Date], day),7)+1

v-jingzhang — Fri, 29 Apr 2022 09:37:57 GMT

Amit's formula should work. Have you tried that? You can create two new columns with them and get the result you want.

Best Regards,
Community Support Team _ Jing