Index based on other column

[Delion]

Hi, I want to create index based on column Week and use this column for sort in Bar chart

Many thank

[VahidDM]

Hi @Delion 

You can add a new column to your table to show the YYYY number + Week number like this:

202101

202102

.

.

.

202153
202201
202202

then use that to create a RANK column.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ALLUREAN]

Hi, @Delion 

Do you use calendar date table or this is the data structure?

[Delion]

Data structure

[ALLUREAN]

Please check this example in that case:

Weeks are ordered by 1-53

https://www.dropbox.com/s/xf3ttggw31a6w5h/Index%20based%20on%20other%20column%20%28allure-analytics....

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[amitchandak · Accepted solution]

@Delion , if you have date this needs to be created based on date

new columns

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)