Forum Discussion
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 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.
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
)
2 Replies
- amitchandak
Super User
You can create a column Rank
Rank = rankx(filter(Table, [Full_name] = earlier([Full_name]) ), [Date],,asc,dense)
Andrew_na_langThe 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
)
