Forum Discussion
Need Help: Count Customers based on filters & Identify New/ Lost Customers
Hi,
I'd like to solve this question in steps. You may refer to my solution to your first question in this PBI file. For question 4 (Only Implementation services), why should the answer be 2? - there is no billing for Customers 2 and 3 in India in Feb 2015. In the matrix, i have also shown Customer names for your additional names. You should be able to drag any field in/out of the filter/matrix.
Let me know how this works. If there are no mistakes, we will proceed to the next questions.
Hope this helps.
Hi,
Thank you for the feedback. Could you kinldy help me with data for a few years so i can correct for the error. If i add fictitious data, i may still not be able to catch the error.
Super UserHi,
I'd like to solve this question in steps. You may refer to my solution to your first question in this PBI file. For question 4 (Only Implementation services), why should the answer be 2? - there is no billing for Customers 2 and 3 in India in Feb 2015. In the matrix, i have also shown Customer names for your additional names. You should be able to drag any field in/out of the filter/matrix.
Let me know how this works. If there are no mistakes, we will proceed to the next questions.
Hope this helps.
Let me start by saying Thank you Very much!
Yes, you are right that expected answer to Qn 4 is not 2 as they have zero revenue in the period. I should have put it as USA for Feb should be 2 (Customer 5 & 6).
Let me look through your PBI file and see if that works.
Thanks again
- Ashish_Mathur
You are welcome. Look forward to your feedback.
Dear Ashish - This works perfectly! Great work! Thank you!
Posting this as Accepted Solution.
Would you mind helping on the new clients and lost clients measure?
- Ashish_Mathur
You are welcome.