Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tagging latest week in calculated column

Hi, I have a table having Year, Month, Week. I want to add another column to give me lastest week of current year as ThisWeek, and other tags as Week-1, Week-2, Week-3. Data is from 2018 onwards, a...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    you can try to create a yearweek column and then create last three week column

    Yearweek = 'Table'[Year]*100+'Table'[Week]

Column = 
VAR _rank=RANKX(all('Table'),'Table'[Yearweek])-1
return if(_rank=0,"This week", if(_rank<4,"Week-"&_rank))

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

you can try to create a yearweek column and then create last three week column

Yearweek = 'Table'[Year]*100+'Table'[Week]

Column = 
VAR _rank=RANKX(all('Table'),'Table'[Yearweek])-1
return if(_rank=0,"This week", if(_rank<4,"Week-"&_rank))

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thanks for the quick support 🙂

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    you are welcome