Forum Discussion
Andrew_na_lang
Helper V
Helper VLabel the order ids as first, second, third, forth, and last order according to the pickup date
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 seq...
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
)
amitchandak
Super User
Super UserYou can create a column Rank
Rank = rankx(filter(Table, [Full_name] = earlier([Full_name]) ), [Date],,asc,dense)
Andrew_na_langHelper V
Helper VThe 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
)