Forum Discussion
Frequency
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 a...
smpa01
Community Champion
Community ChampionAnonymous no worries mate !!! we speak in DAX here.
Is it possible to provide some sample data and desired output?
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!!