Forum Discussion

etane's avatar
etane
Icon for Helper V rankHelper V
2 years ago
Solved

Request DAX For Ranked Order Date Tracking for Different Orders on Same Date

Hello.   I am trying to track order velocity of how fast a customer gets to order number 2, 3, 4 and so on.  So, I need to calculate differences between two order dates.    However, with the curr...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    thank you for your message, and pleaes check the below pictures and the attached pbix file.

     

etane's avatar
etane
Icon for Helper V rankHelper V
2 years ago

Jihwan_Kim 

 

Hello.

 

I was able to adapt your DAX to my actual model.  And, it accurately depicts dates by Order #.  However, I can't write a measure that shows the average days it takes from one order to the other.  

Below, the datediff works in calculating days it takes to make next order:

However, it doesn't work when I apply an iterative function to it to try to get the average days:

Could you please tell me what I might be missing in the "Days to 2" DAX above?  

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,
I am not sure what visualization is used in you image.

 

expected result measure: =
AVERAGEX (
    VALUES ( Sales[Customer] ),
    DATEDIFF ( [Order 1 date], [Order 2 Date], DAY )
)

 

 

  • etane's avatar
    etane
    Icon for Helper V rankHelper V
    2 years ago

    Thank you!  Exactly what I am looking for: