Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |