How to convert YYYYWW into date format?

[farmanalishah]

Hello Folks,

I have column Weekid YYYYWW (201601), i want to convet into proper date format.

Anyone here please help me

Regards

Farman

[amitchandak · Accepted solution]

I have year column in my date table else you can use

Year(Date[Date]) in please of Date[Year]

Similarly, Week Number = WEEKNUM('Date'[Date])

Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])

[amitchandak · Accepted solution]

I have year column in my date table else you can use

Year(Date[Date]) in please of Date[Year]

Similarly, Week Number = WEEKNUM('Date'[Date])

Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])

[farmanalishah]

Thank you Amitchandak

[amitchandak · Accepted solution]

@farmanalishah , please mark the solution.