Misunderstanding - ( IN VALUE ) expert help

[Anonymous]

Hi,

I have this following table to count both :

• New customers
• Active customer who buy this month.

This is the Measure for New Customer column:

The Question is, How is that possible to get new customers using ( IN VALUE ), I tried to understand many times but I couldn't.

please help

[tamerj1 · Accepted solution]

Hi @Anonymous 

VALUES of date is evaluated in the current filter context. Therefore in jan 2008 for example it will return the dates from 1/1/2008 to 31/1/2008. 
the first variable creates a table (also evaluated in the current filter context) that contains two columns: the customers available in rhe current filter context and the date of of the first sale of each customer. 
Then FILTER iterates over this table keeping only the rwos where the first sale date is available in the dates of the current filter conext. 
it is a beautiful code!

[Anonymous]

Totally agree, very amazing code and this is why I have been trying to understand it because it has a very powerful practice!

[amitchandak]

@Anonymous , refer to my method of using isblank

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