Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

  • Ciria's avatar
    Ciria
    Advocate III
    8 years ago

    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,