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 

what's the expected result for 2020 Dec and 2019 Dec weeks?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    all others, should be blank

    • 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 🙂