Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim ,
You can download the sample file from below link :
https://drive.google.com/drive/folders/1MFRmKzqo9byLA_6QkPl3LBAD91otY5IF?usp=sharing
Thanks
Hi,
You may download my PBI file from here.
Hope this helps.
You are welcome.
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
can you provide sample data in text format?
Proud to be a Super User!
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 :
Hi @vanessafvg ,
You can download the file from the below link :
https://drive.google.com/drive/folders/1MFRmKzqo9byLA_6QkPl3LBAD91otY5IF?usp=sharing
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |