Check if the "Value" is a new value or and a old value

[Anonymous]

Hello, 

For my project, I have a table of a compagny sales which spans 4 years. There are the names of customers and I would like to know for 2022 if customer is a new customer or an old customer.

And in a second time, I would like to know every cusomers which aren't coming back in a compagny to buy something.

I tried something like this : 

Test =
var _1 = COUNTX(FILTER('Table', 'Table'[Customer number] = EARLIER('Table'[Customer number]) && 'Table'[Order created].[Year] < EARLIER('Table'[Order created].[Year])),'Table'[Customer number]) +0
return
if(_1 > 0, "True", "False")

Thank you in advance

[amitchandak]

@Anonymous , Refer my blog on same, Change duration based on need

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497

[Anonymous]

Thank for your answer ! 

But I would like a "list" of these values, not a measure. 

Is it possible ? 

[Icey · Accepted solution]

Hi @Anonymous ,

I modify the measures based on the sample below:

Solved: Interact with line chart to analyse increase/decre... - Microsoft Power BI Community

Please check the attachment and check if this meet your requirements.

Best Regards,

Icey

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

[Anonymous]

Hi, thank you for your answer

I think that the solution is in your link but I don't have enough time to do it. 

Regards,