Forum Discussion
Time comparison multiple years
Hello everyone, I’ve been struggling the past few days with DAX-formulas to compare several years. On the internet there are several formulas but none of them gives me the result I want. What’s th...
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
Hi Anonymous
What about the use of LASTNONBLANK??
This function may return the last date with sales for every customer. I guess adding a IF function you could classify every customer.
I guess a customer with no sales on the present year, may be classifed as "lost customer"?
Regards,