cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alevandenes
Helper III
Helper III

Priority column with ascendent numbers based on other column

Hi community,

 

I have a column that displays the stock i have in the warehouse. I would like to create a "priority" column that automatically assigns ascendent numbers based that column. In blue below what i want to achieve: any suggestions?

 

alevandenes_0-1636973203836.png

 

1 ACCEPTED SOLUTION

3 REPLIES 3
amitchandak
Super User
Super User

@alevandenes , a new column

Rankx(Table, [Stock],,asc, dense)

alevandenes_0-1636975404195.png

Hi @amitchandak , thank you very much: the formula works! do you know how can i integrate the orange column into it? i want the priority numbering dependent on the production week. Thanks a lot in advance

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors