BetweenDates

[Anonymous]

Morning all! 

I have a Calendar Table and a Transaction Table that has the following info

ID | TransactionDate

-----------------------

1 | 24/01/2020

2 | 03/03/2020

3 | 14/04/2020

etc...

I want to create a column (or measure) to identify an Active Customer. The logical would be.

If the TransactionDate is between [10 months before an End Period ; EndPeriod]

                                        Then identify that customer as Active.

                                        Otherwise as Inactive.

The EndPeriod is the tricky part, because I want that to be dynamic (if possible).

I want to have a slicer in which I pick the date from my Calendar Table and I want my conditional column to identify that Date as the EndPeriod and perform the above calculations based on that.

The final goal is to count Ative Customers in a given period.

Thanks

[amitchandak]

@Anonymous , These two should offer some help

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

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.