Count a sale for a customer only outside of 15 days from the first sale, and any subsequent sales
My dashboard for customer sales has many "duplicates". For example: Customer Bryan Smith has made 7 purchases in the past year total. For my specific dashboard, I want to filter out the cells that are not highlighted in green (rows 3, 7, and 😎 because they are within 15 days of a previous purchase. I have a Customer Key (CusKey) as a unique identifier for my customers. The calculated column I created is: dupeTest = VAR MaxDateKey = 'Sales'[DateOfPurchase] VAR MinDateKey = maxdatekey - 15 VAR Calc = CALCULATE ( COUNTROWS ( 'Sales' ), FILTER ( 'Sales', 'Sales'[DateOfPurchase] >= MinDateKey && 'Sales'[DateOfPurchase] <= MaxDateKey && 'Sales'[CusKey] = CusKey ) ) RETURN IF ( calc > 1, 0, 1 ) And then to get my desired result, I filtered out all 0's in that column so those entries wouldn't be in my data. The data I'm trying to filter out is still present. In this specific example with my formula, row 3 would be erased because it is within 15 days of row 1's date (this is what I want). Row 7 and 8 still remain although they are 15 days within row 6. My desired results after implementing that formula is as follows: Help would be greatly appreciated!
Count how many times a transaction is made, for each costumer
Hello, hope you'll be able to help me.. So, what I have is: 2 Tables related to each other by a many to one relationship. The first table contains the names and the Serial Number of each costumer The secondo table is made by many coloums (Serial Number - day and time of the transaction - transaction $ -...-...) I need to know with which frequency each costumer make a transaction, like: 3 times per day this costumer (Serial Number) has made a transaction and how much is the total amount and 10 costumer make 4 transaction every day How can I do that? Thank you so much
Count rows with cunditions by date
Hi, I've a data base like the following, but I'd like to get the number of Request "Mode de traitement = TRAITEMENT IMMEDIAT" by month. Request | Date | Mode de traitement n°1 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT n°2 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT n°3 | 10/04/2018 10:33 | TRAITEMENT IMMEDIAT n°4 | 10/05/2018 10:06 | TRAITEMENT IMMEDIAT n°5 | 10/05/2018 09:57 | CREATION DOSSIER n°6 | 10/05/2018 09:53 | CREATION DOSSIER n°7 | 10/06/2018 09:52 | CREATION DOSSIER n°8 | 10/06/2018 09:52 | TRAITEMENT IMMEDIAT n°9 | 10/06/2018 08:27 | TRAITEMENT IMMEDIAT n°10 | 10/07/2018 08:28 | TRAITEMENT IMMEDIAT n°11 | 10/07/2018 08:29 | TRAITEMENT IMMEDIAT n°12 | 10/07/2018 08:33 | TRAITEMENT IMMEDIAT n°13 | 10/08/2018 08:46 | TRAITEMENT IMMEDIAT n°14 | 10/08/2018 09:52 | CREATION DOSSIER I tried to creat an other base with the months using the first day of each month ([Month] = 01/04/2018 ; 01/05/2018 ; ...) and adding a calculate column [#TraitementImmediatByMonth], but I didn't success. How could I get get the following result ? Month | #TraitementImmediatByMonth 01/04/2018 | 3 01/05/2018 | 1 01/06/2018 | 2 01/07/2018 | 3 01/08/2018 | 1 Thank's for your help !
