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

     

     

     

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