Find Order Ranking of the customers based on Order date and order status

[Andrew_na_lang]

Hello,

My orders table where I need to rank the order of our customer according to their customer id, order date and not to include the Order cancelled to the ranking.

What I need to happen in power bi is a calculated column with the order ranking like this:

Pleasr help! I have been trying to solve this for a coupoe of days noe.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached file.

It is for creating a new column.

Rank by customer and order date CC =
VAR _currentcustomer = Data[Customer_ID]
VAR _newtable =
    FILTER (
        Data,
        Data[Customer_ID] = _currentcustomer
            && Data[Order_status] = "Complete"
    )
VAR _rankingresult =
    RANKX ( _newtable, Data[Order_date],, ASC )
RETURN
    IF ( Data[Order_status] = "Complete", _rankingresult )

[Andrew_na_lang]

@Jihwan_Kim You are indeed a super user! It worked. Thank you.