I need to change this formula so that the format will be YYYY-WW
THis formula works but the result is 201801 or 201802 so without the '-' between Year and Week
How do i change this formula ?
Go to Solution.
Create a caluclated column
Column = IF(WEEKNUM([Date])<10,FORMAT([Date],"YYYY-0WW"),FORMAT([Date],"YYYY-WW"))
View solution in original post
But it won't be a number of course:
Week Number =
YEAR ( 'Date'[Date] );
& CONCATENATE (
IF ( WEEKNUM ( 'Date'[Date] ) < 10; "0"; "" );
WEEKNUM ( 'Date'[Date] )
Please mark the question solved when done and consider giving kudos if posts are helpful.
@AlB then how do i fix the issue ?
Ive altered the formula but, like you said, it returned an error that it can't convert type Tekst to Number.
@AlB any ideas ? a different formula is also ok
@v-juanli-msft that did the trick, thank you 🙂
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!