topic Misunderstanding - ( IN VALUE ) expert help in DAX Commands and Tips

Misunderstanding - ( IN VALUE ) expert help

Anonymous — Tue, 05 Apr 2022 14:24:37 GMT

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

Re: Misunderstanding - ( IN VALUE ) expert help

amitchandak — Tue, 05 Apr 2022 14:58:35 GMT

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

Re: Misunderstanding - ( IN VALUE ) expert help

tamerj1 — Tue, 05 Apr 2022 17:06:04 GMT

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!

Re: Misunderstanding - ( IN VALUE ) expert help

Anonymous — Sun, 10 Apr 2022 22:29:42 GMT

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