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.
I am trying to calculate repeat customers after 1st 30 days and 2nd 30 days as separate groups. I have enclosed a link to a table showing new customers and returning customers. Pleae help anyone with any ideas. Many thanks for your help.
https://drive.google.com/open?id=1lK6N56cNyQMOeCMufWi_GGCYg6FNvh5U
@powerbiwizkid wrote:
I am trying to calculate repeat customers after 1st 30 days and 2nd 30 days as separate groups. I have enclosed a link to a table showing new customers and returning customers. Pleae help anyone with any ideas. Many thanks for your help.
https://drive.google.com/open?id=1lK6N56cNyQMOeCMufWi_GGCYg6FNvh5U
Your requirement is not clear for me. What is the expected output and how to get it the the data in your table?
This is my current returning customers DAX formula based on DAX patterns.
I need to modify that DAX formula to show repeat customers from first purchase after 1st 30 Days, 2nd 30 Days as separate groups. I'm thinking the best approach is to use INTERSECT for the second argument (underlined portion of DAX formula) of returning customers but not quite sure how to do it. Please help anyone with any ideas. Many thanks.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |