Dax to make a weeks columns based on a date column

[adyla]

Hello everyone, 

I hope you are doing well

I would like to know how can i create a week column (like 1st week, 2nd week, 3th week and 4th week) based on a date column

[FreemanZ]

try to create a new column with this:

WeekNum = WEEKNUM([Date],2)

[FreemanZ]

or like this, to be more close to your expectation:

WeekNum = “Week”&WEEKNUM([Date],2)