Forum Discussion
Calculate Repeat based on 30 Days Rolling Window
Hi Team, I have a raw table contaning, Date, OrderID & Agent. I want to calculate Repeat(Count of OrderID) based on OrderID & Agent with intervals of 0 to 7 days, 8 to 15 days & 15 to 30 days window.
Following is the desired output:
Will be highly appreciated, if someone can help, i have been tring to do this from many days..
OK, pls try again this
6 Replies
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Ahmedx
Thank you for your response.The PBIX works perfectly within the context of current month only. For instance, An order (Order 1) came on 30th June handled by (Agent 1), Order 1 also Came on 1st July handled by Agent 1 again, in current context it not looking for repeat for different slabs in the month of July, it is just counting it at 1 for the month of june.
Can you please help me solve this?in the month of July how much should be "0-7 Days Repeat" for Agent 1
Ahmedx
It should be zero, every Unique OrderID in the Table should be tracked on 0-7 Days, 8-14 Days & 15-30 Days
