How to show Sales made by returning Customer each time

[AshDil]

Hi,

I have data as follows:

I want to show sale made by the customer each time.

Please help me to do.

Thanks,

AshDil

[Ashish_Mathur]

Hi,

Share data in a form that can be pasted in MS Excel.

[ryan_mayu]

@AshDil 

what's the expected output?

[AshDil]

Hi @ryan_mayu ,

I want the output as follows:

Please help me to do.

Thanks,

AshDil.

[ryan_mayu · Accepted solution]

@AshDil 

maybe you can try to create a new column

Sales time = 
var _1=CALCULATE(min('Table'[Date]),ALLEXCEPT('Table','Table'[Cust_ID]))
VAR _2=minx(FILTER(all('Table'),'Table'[Cust_ID]=EARLIER('Table'[Cust_ID])&&'Table'[Date]>_1),'Table'[Date])
VAR _3=minx(FILTER('Table','Table'[Cust_ID]=EARLIER('Table'[Cust_ID])&&'Table'[Date]>_2),'Table'[Date])
VAR _4=minx(FILTER('Table','Table'[Cust_ID]=EARLIER('Table'[Cust_ID])&&'Table'[Date]>_3),'Table'[Date])
return SWITCH('Table'[Date],_1,"Sale 1",_2,"Sale 2",_3,"Sale 3",_4,"Sale 4")

pls see the attachment below

[AshDil]

Hi @ryan_mayu ,

Thank you so much for your solution. It helped me.

Thanks,

AshDil

[ryan_mayu]

you are welcome