Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
@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))
Proud to be a Super User!
@Anonymous
what's the expected result for 2020 Dec and 2019 Dec weeks?
Proud to be a Super User!
all others, should be blank
@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))
Proud to be a Super User!
thanks for the quick support 🙂
you are welcome
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
79 | |
59 | |
36 | |
35 |
User | Count |
---|---|
99 | |
57 | |
56 | |
46 | |
40 |