Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a column that reports the Customer Name. I have another column that reports the date the customer was first retained.
How would I return the Customer Name that repeats every year in a desired time frame? I want to know which customers are repeat customers year after year.
Solved! Go to Solution.
An alternate suggestion. Are you simply wanting to count the number of period a customer does business with you? For example, if a customer does business with you through 2016 and 2017, you want to get a count of 2? The below method will let you specify that period, using a column from a date table.
Start by creating a simple distinct count measure
Customer Count = DISTINCTCOUNT(Table[Customer Name])
Next we iterate that count across whatever time period you want to do:
Customer Repeats = SUMX( VALUES(DateTable[Year]), [Customer Count] )
Now put [Customer Repeats] into a table with 1 Customer Name as your row labels.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Felix, would it be a count function if I want to know the actual customer not just the number of customers?
Thanks!!
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAn alternate suggestion. Are you simply wanting to count the number of period a customer does business with you? For example, if a customer does business with you through 2016 and 2017, you want to get a count of 2? The below method will let you specify that period, using a column from a date table.
Start by creating a simple distinct count measure
Customer Count = DISTINCTCOUNT(Table[Customer Name])
Next we iterate that count across whatever time period you want to do:
Customer Repeats = SUMX( VALUES(DateTable[Year]), [Customer Count] )
Now put [Customer Repeats] into a table with 1 Customer Name as your row labels.
This works great, thank you!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |