Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How detect exits from a company

Hi community!!

I'm dealing with a PBI dashboard that shows information about customers.

For each 1st day month, the excel has a record with ID of customer.

If a customer declined the subscription, the ID will not be shown anymore.

For example:

This customer entered the pool customer in May, still in June, also in July, but in August the customer is not anymore in the pool.

At this point I need to save in some place +1 (for the exit in Aug). I don't know exactly how to do that, because I don't have the record in Agust in the excel , so I think it can not be like a calculated column. Maybe a measure? I imagine that I should iterate over each ID each month, but I don't know how start.
Any help will be appreciated!! Thank you!!

 

Need Help

2 Replies

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Typically, you would add a Date table in your model that has a relationship to your example date column. The Date table would have all the months and you would write a measure that looks to see if there are no rows in the current month but there are rows in the prev month. Or look for earliest month with no rows, if you need exit month for example.

     

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes, I have a data table but I should find if there are specific rows, not rows generally. Because if I do like you say, It will count the qty for each month, and I don't need it.

      I need to count if each record (ID) exist in the next one , and when there is not the ID +1. 

      But I don't know how create the measure 😞 

      Thank you everybody!