Frequency

[Anonymous]

Hi

I have a table with these columns:

Costumer | Date | Month Number | Sale

I would like to select an interval of date (slicer) and bring this number:

How many costumers have purchased at least 1 product in 3 differents months in that selected time interval 

PS: sorry for my english, i'm brazilian

[smpa01]

@Anonymous  no worries mate !!! we speak in DAX here.

Is it possible to provide some sample data and desired output?

[Anonymous]

Hello again! Sure! thats not the real table because i cant share the information, but is something like this:

Costumer	Product	Date
Costumer 1	Product x	01/10/2021
Costumer 2	Product x	01/10/2021
Costumer 1	Product x	01/10/2021
Costumer 1	Product x	01/09/2021
Costumer 1	Product x	01/08/2021
Costumer 2	Product x	10/10/2021
Costumer 3	Product x	05/09/2021
Costumer 3	Product x	10/08/2021
Costumer 3	Product x	07/07/2021
Costumer 3	Product x	01/11/2021

and the output would be: 

When i select a month the card visualization will show how many costumers purchased at 3 differents months in the last 5 months (if i select july for example it will be the 5 months before july)

For example (for this data table): 

If i select november, the measure will return 2 costumers, because between november and june 2 costumers purchased in 3 differents months. 

Thank you very much!!