Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
we need reach a 'previsibility' of new ordes for next week, reviewing last 02 or 03 orders to get a previsibility of 'WHEN' customer will buy again. Based on that previsibility we would like to start CRM actions for cases where would be expected a new order for yesterday (for example) but not realized...
Let´s say that looking sales table, we realize that 'Customer A' bought on '01/01/2018', '21/01/2018' and 10/02/2018 so the average time (we need calc) for new order is '20 days'. After that we can expect 'customer A' buying again on '02/03/2018'.
There is DAX formula to check this interval based on last dates of purchase and calc this average?
Hi @jr3151006,
I'm wondering if you could firstly create two measures to get the last order date, the first order date of the last 02 or 03 orders for a customer. (In order to do it, you may need to rank the order dates for each custom first.)
Then use DATEDIFF function to create a new measure to calculate the average days that a customer will order again.
Measure = DATEDIFF ( [First Order Date], [Last Order Date], DAY ) / 2 --Divided by the value according to your needs
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |