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 at least 1 product in 3 differents months in that selected time interval
PS: sorry for my english, i'm brazilian
2 Replies
Anonymous 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!!
