Forum Discussion
Time comparison multiple years
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!
Hi Ciria,
Thanks for your reply!
Sam McKay makes wonderful videos and the video you mentioned is also an excellent video by Sam but the video doesn't help me to answer my questions. I'm still looking for a solution to connect the number of lost-steady and new customers to the Sales-amount and compare these figures with the figure of the previous year.
Is there someone who can help me?
Thanks in advance,
With kind regards,
Cor
