Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago
Solved

Week Number calculated coloumn

Hi, i am using the below calculated coloumn to arrive at week number, but the output what its is giving me is based on Calendar year   Week Number = WEEKNUM('Date'[Date])   I need output based o...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Create a column start of year

 

start of year = startofyear([Date],"06/30")

Weekno = quotient(datediff([start of year],[Date],day),7) +1

OR

Weekno = quotient(datediff([start of year],[Date],day)+1,7) +1

 

You can move year start to week start like

Week Start date = 'Table'[start of year]-1*WEEKDAY('Table'[start of year],2)+1

 

https://docs.microsoft.com/en-us/dax/quotient-function-dax