Optimizing code, loop for

Hi, experts, any help? I have this code:

 

ifs(
   Weeknum([Date])=1, “Week 1",
   Weeknum([Date])=2, "Week 2”,
   .
   .
   .
   Weeknum([Date])=52, "Week 52”
   )

 

That code works fine, but I dont want to write 52 lines

This is an idea but something like this is possbile?

 

for i in (1, 52) {
   if(
      Weeknum([Date])= i, "Week "+ i
      )
}

 

Thanks!

0 1 74
1 REPLY 1
Top Labels in this Space