Forum Discussion

walker4545's avatar
walker4545
Frequent Visitor
3 years ago
Solved

Number Recurring Value by Date

Hello Power BI gurus,    I need to write a DAX statement that can order what number a customer's purchase was according to when the purchase was made:   Order Table Customer ID Product ID D...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Expected result CC =
RANKX (
    FILTER ( Data, Data[Customer ID] = EARLIER ( Data[Customer ID] ) ),
    Data[Date],
    ,
    ASC
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Expected result CC =
RANKX (
    FILTER ( Data, Data[Customer ID] = EARLIER ( Data[Customer ID] ) ),
    Data[Date],
    ,
    ASC
)