Forum Discussion
How to convert YYYYWW into date format?
Hello Folks, I have column Weekid YYYYWW (201601), i want to convet into proper date format. Anyone here please help me Regards Farman
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])Anonymous , please mark the solution.
Thank you Amitchandak
Anonymous , please mark the solution.