Forum Discussion

Marcus_S's avatar
Marcus_S
Frequent Visitor
4 years ago
Solved

Calculate intervall off orders

Hello everyone!   A colleague would like to have an overview that shows the rythm in which the customer always orders in order to anticipate the next order. We have a table that contains the custo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Marcus_S ,

     

    My table is :

     

    You can follow the below steps:

    1.Add a new column in the table to calculate the datediff

    Date_Diff =
VAR curdate = 'Table'[Order date]
VAR prevoius_date =
    CALCULATE (
        MAX ( 'Table'[Order date] ),
        FILTER ( 'Table', 'Table'[Order date] < curdate )
    )
RETURN
    DATEDIFF ( prevoius_date, curdate, DAY )

     

    2.Create a measure to calculate the average about the new added column

    Measure =
AVERAGE ( 'Table'[Date_Diff] )

     

    If I misunderstand your demands, please feel free to let me know.

     


    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Marcus_S , Try a new column like

 


New column = datediff( maxx(filter(Table, [Customer number] = earlier([Customer number]) && [Order Date] = earlier([Order date])),[Order date]),[Order Date] ,day)