Forum Discussion
Time comparison multiple years
Hi Ciria,
Thanks for your reply!
I've tried and tried and uptil now I haven't found a solution. I've made a dummy model and hopefully you can help me to count the customers for each year and the Sales.
The data:
The report I want to calculate for each year:
The relationship I use between the 2 tables:
Hopefully you can help me with my challenge.
Thanks in advance,
Cor
I’ve made a mistake in the report: the lost revenues % # Customers was wrong. The correct report should be:
Chrs,
Cor
Hi Anonymous
Yesterday I was precisely watching a video in youtube about how manage a situation like yours.
https://www.youtube.com/watch?v=SOkBdbu4sVc&list=LLECfzwATlNAWnYdkkGLenGw&index=3&t=50s
There are three parts, but your model looks definately simpler than her one.
Take a look it and let me know if it works.
DISTINTCOUNT looks definately the formula you need. A Both direction relathionships I think is not necessary, single side could be ok.
Good Luck!
Hi Ciria,
Thanks for your reply, weekly I see the Curbal DAX-Friday-videos, Ruth does a good job. :-)
In the meantime I’ve made the DAX-formulas for New and Steady customers:
Can you help me with the formula for Lost customers? Now I have the numbers for New and Steady customers, how can I connect these numbers with the amount of Sales?
Thanks in advance,
Cor
Hi Anonymous
I'm afraid of without having the model I cannot help you more, additionally your DAX looks pretty advanced, so I am not sure if I will be able to help you any further....
About your question, maybe this video helps you to clasify your customers....
https://www.youtube.com/watch?v=Nboy_u8Iv74&index=2&list=LLECfzwATlNAWnYdkkGLenGw
Keep me posted if it works!
