Forum Discussion
Continuous cumulative count based on discrete dates
Hi,
Please find attached the solution workbook.
Hope this helps.
Hi,
Go To Home > Transform Data. click on The Categories query and double click on Source. Make changes there and click on OK. Click on Close and Apply.
Hope this helps.
Great, did this as well and it works. I am also wondering in case there if there is a customer buying two cars on the same day, how would it reflect?
If the customer does not have any car and purchases his first and second cars on the same date, then ideally this customer should be counted as zero cars before the purchase, and 'two cars' on the next day
That is how it should work. Test it yourself.
Hi Ashish, thank you so much for all your support, it is all working, however when I create a relationship with another table (it is a one on one relationship based on the customer ID), the formula is breaking, would you have any idea why? or would I need to share more information
I have no idea.