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!!
