Label the order ids as first, second, third, forth, and last order according to the pickup date

[Andrew_na_lang]

Hi Power Bi Family,

I have this visual that shows the name of the customer on the left table and all of his orders on the right table sorted by the pickup date. I would like to create show the sequence of orders like first, second, third, ...... and Last instead of the order id (Zc876, ru505, xr253 .... )

My end goal is to essentially create a bar chart that would tell me which order (first, second, third, fourth, .... last) has the most number of unique items of all customers. 

[amitchandak]

@Andrew_na_lang ,

You can create a column Rank

Rank =  rankx(filter(Table, [Full_name] = earlier([Full_name]) ), [Date],,asc,dense)

[Andrew_na_lang · Accepted solution]

The formula I used worked perfectly according to what I was trying to achieve is: 

Order Rank =
VAR Customer = item_kpis[customer_id]
RETURN
    RANKX (
        FILTER ( item_kpis, item_kpis[customer_id] = Customer ),
        item_kpis[pickup_date],
        ,
        ASC,
        DENSE
    )