Forum Discussion
How to get lost customers over a date range?
Hi guys, I am currently trying out Pbi and evaluating it for my company. I have a test case that I cannot seem to work out. I am not fluent in DAX or Pbi. This is a snapshot of my data. What I w...
BhaveshPatel
Super User
Super UserTHERE ARE COUPLE OF QUESTIONS YOU SHOULD MAKE IT CLEAR BEFORE ANSWERING YOUR QUESTION
1.How do you define the particular contract is active or inactive. Is there any criteria?
2. Is there any business logic that identifies the lost customers?
3. it would be better to share dimensions table in your data model as well which will make your question more clear.
Sorry for missing these points out.
1. Ideally my X-axis has a range of dates, could be any 7 days i input in my filter. For each day in my x-axis, if my [start date] <= the date, and [end date] > the date then it's considered active. Anything outside of this range is considered inactive.
2.Lost customers are those contracts that were present during the start of the date range and by the end of the specified date range is no longer present.
3. i don't understand what you mean by dimensions table.
Thanks in advance.
1. Ideally my X-axis has a range of dates, could be any 7 days i input in my filter. For each day in my x-axis, if my [start date] <= the date, and [end date] > the date then it's considered active. Anything outside of this range is considered inactive.
2.Lost customers are those contracts that were present during the start of the date range and by the end of the specified date range is no longer present.
3. i don't understand what you mean by dimensions table.
Thanks in advance.