cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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, and latest is of 2021 Week-35, so I want to tag last Wk-32, 33, 34 & 35 of 2021. When new data comes, say of Wk-36, that should be tagged as ThisWeek, and past weeks tags updated. Have been trying for a while, but my code always tags Week-53, the max of all as ThisWeek rather, max of 2021 as this week. Please help. See snip below for code and table.

1 ACCEPTED SOLUTION
Super User

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))

Proud to be a Super User!

5 REPLIES 5
Super User

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

Proud to be a Super User!

Frequent Visitor

all others, should be blank

Super User

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))

Proud to be a Super User!

Frequent Visitor

thanks for the quick support 🙂

Super User

you are welcome

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors