repurchase

2 Topics

Calculate Customers with more than one order of X product
Hello masters, I wish to create a measure which calculates the number of customers who REPURCHASED a product = bought X product in more than 1 different orders (in a dynamic range of dates). Please note that a repurchase occures when a product is purchased by a specific customer in more than 1 order (2/3/4.....). it actually counts the customers who bought x product in more than 1 and above order IDs. Below example of data and the desired measure result: Date Order ID Customer ID Product 01/01/2022 AAA 111 x 01/01/2022 AAA 111 y 03/01/2022 BBB 111 x 04/01/2022 CCC 222 y In this range of dates - product x was repurchased by 1 customer (111) , product y was not repurchased by any customer. thanks in advance champs, Amit
Solved
akfir
4 years ago Place DAX Commands and Tips
6KViews
0likes
13Comments
Repurchase counter
Hello guys, this is my first post and I need help. I have a huge database with the columns: day, state, costumer code, SKU, origin, state and month. I need to count how many times a costumer made a purchase in a month, but I need to mark when this code appeared that month. If it is the first time, mark with 1, the second with a 2, etc. I can do that on Excel: =COUNTIFS($D$2:D10087;D10087;$E$2:E10087;E10087) where D is the Costumer Code and E is the Month. (I do that every line from D2 to D10087) I tried that on Power BI, creating a new table: Calc_Repurchase = SUMMARIZE(db, db[Costumer Code], db[Month], "Count", DISTINCTCOUNT(db[Day])) It works, but it only shows the total number of times the customer made the purchase in a month. And isn't what I want. I created a new column at the original table using Column = COUNTX(FILTER(db, db[Day] <= EARLIER(db[Day])), db[Costumer Code]), but returned a message error tha my computer doesn´t have enough memory. Regards, Rafael
rafarother
5 years ago Place DAX Commands and Tips
1.2KViews
0likes
3Comments