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, 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:

 

DAX%20New%20and%20steady%20customers
DAX New and steady customers.JPG980x663 46.2 KB

 

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

  • 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,