Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Customer First Time Calculation Without Earlier

Hi All, First of all I'm sorry but this article is a little long but It really confusing thing for me I try to explain clearly I'm in trouble with Earlier function. It is really significant funct...
Need Help
Show and Tell
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can change your [First Time] column to 

     

    First Time = RANKX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer])),'Table'[Date],,ASC,Dense)

     

    Use another measure for counting customer for 3 year break:

     

    _3 Year Break = CALCULATE(DISTINCTCOUNT('Table'[Customer]),'Table'[3 Year Break] = 1)+0

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can create a column like this

Last Date = maxx(filter('Table' ,[Date] < EARLIER ( [Date] ) && 'Table'[Customer] = EARLIER ( 'Table'[Customer])),'Table'[Date])

 

If this null then it first visits

 

Now a new column

datediff([Last Date ],[Date] ,DAY) // diff from last order

datediff([Last Date ],[Date] ,Month)

 

You can change such a column in measure with two changes

 

Last Date = maxx(filter(allselected('Table') ,[Date] < max( [Date] ) && 'Table'[Customer] = max( 'Table'[Customer])),'Table'[Date])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

    I tried your measure but it doesn't return the expected result.

    I want to find customer count for each date. I shared the screenshot in the previous post.

    I need something like that.

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      You can change your [First Time] column to 

       

      First Time = RANKX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer])),'Table'[Date],,ASC,Dense)

       

      Use another measure for counting customer for 3 year break:

       

      _3 Year Break = CALCULATE(DISTINCTCOUNT('Table'[Customer]),'Table'[3 Year Break] = 1)+0

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai