topic Calculation of Lost Customers Vs New Customer in same graph in Desktop

Calculation of Lost Customers Vs New Customer in same graph

Anonymous — Thu, 15 Apr 2021 17:53:20 GMT

Hello !

After reading many blogs and tried many calculation methods I am looking for a solutions to compare the turnover value for lost customers and new customers.

Condition for Lost Customers:

if current year ytd = 0 and prev full year > 0 then Lost Customer current year = prev year turnover

Condition for New Customers:

IF current year ytd > 0 AND prev full year = 0 THEN new customers current year = current year ytd turnover

And compare the value for each year (lets now for example 2021 )

I have attached a demo of output graph I am looking for.

The structure of the raw is something like this :

Needed Graphs :

1. Lost Customer Graph :

2. Lost Vs New customer graph

3. New Customer Graph:

Any suggestion would be really appreciated.

Thanks !

Re: Calculation of Lost Customers Vs New Customer in same graph

vanessafvg — Thu, 15 Apr 2021 18:00:28 GMT

can you provide sample data in text format?

Re: Calculation of Lost Customers Vs New Customer in same graph

Jihwan_Kim — Thu, 15 Apr 2021 18:04:09 GMT

Hi, Anonymous

Please check the sample pbix file's link down below.

I created it today for another topic but I think it is related.

All measures are in the sample pbix file.

Sorry to say that it is quite difficult to create sample data based on your inquiries.

If you have sample data already, please share the link here, then I can try to look into it.

And I hope the below sample pbix file can help a little bit.

https://www.dropbox.com/s/klfq0dyai1gnonp/cust.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Re: Calculation of Lost Customers Vs New Customer in same graph

Anonymous — Thu, 15 Apr 2021 18:58:42 GMT

Hi Jihwan_Kim ,

You can download the sample file from below link :

https://drive.google.com/drive/folders/1MFRmKzqo9byLA_6QkPl3LBAD91otY5IF?usp=sharing

Thanks

Re: Calculation of Lost Customers Vs New Customer in same graph

Anonymous — Thu, 15 Apr 2021 18:59:12 GMT

Hi vanessafvg ,

You can download the file from the below link :

https://drive.google.com/drive/folders/1MFRmKzqo9byLA_6QkPl3LBAD91otY5IF?usp=sharing

Thanks

Re: Calculation of Lost Customers Vs New Customer in same graph

Jihwan_Kim — Fri, 16 Apr 2021 04:48:43 GMT

Hi,

please check the below link.

https://www.dropbox.com/s/tj11xv5m5fogpaq/Ankibano.pbix?dl=0

I am not sure if I used the sample correctly, but when I saw the data, I think there were no lost customers in 2021.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Re: Calculation of Lost Customers Vs New Customer in same graph

Anonymous — Sat, 17 Apr 2021 18:54:25 GMT

Hi Jihwan_Kim ,

Thank you for your inputs. But unfortunately, the result presented in the PBI file is not the one I am looking for. I am breaking the requirements in the below points :

The full turnover value of 2020 for Customer 1 and Customer 2, should be presented in Jan 2021 value because Customer 1 and Customer 2 Jan 2021 value is 0 or blank.
As customer 1 already have value in Feb 2021, so the Lost customer value in feb 2021 = (2020 Total Turnover value ) – ( Customer 1 2020 turnover Value).

Re: Calculation of Lost Customers Vs New Customer in same graph

Ashish_Mathur — Sun, 18 Apr 2021 02:10:28 GMT

Hi,

You may download my PBI file from here.

Hope this helps.

Re: Calculation of Lost Customers Vs New Customer in same graph

Anonymous — Tue, 20 Apr 2021 13:19:10 GMT

Thank you Ashish_Mathur ,

This was the expected solution.

Re: Calculation of Lost Customers Vs New Customer in same graph

Ashish_Mathur — Tue, 20 Apr 2021 23:03:46 GMT

You are welcome.

Re: Calculation of Lost Customers Vs New Customer in same graph

lakshmi87p — Tue, 25 Jun 2024 05:35:08 GMT

Hi Ashish, I am unable to find the file in given link.