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,
Trying to get a calculated Measure that shows me the New Customers I get by month(for example).
Tryed several DAX samples but none have the effect.
Distinct Customers = My Active Customers in the month OK!
PreExisting Customers = My Base of Customers to the period
New Customers
This one give me the result but only day by day, if I have any agreggate returns Blank:
DistinctCustomers = DISTINCTCOUNT(CUSTOMERS[CUSTOMER_ID]) PreExisting Customers = CALCULATE([DistinctCustomers]; DATESBETWEEN(ORDERS[ORDER_DATE]; 0; FIRSTDATE(ORDERS[ORDER_DATE])-1 ) ) NewCustomers = DistinctCustomers - PreExisting Customer
Please help!
Thank You
Solved! Go to Solution.
Please reference this DAX Patterns article for new and returning customers patterns.
Let us know if you run into any specific problems.
Please reference this DAX Patterns article for new and returning customers patterns.
Let us know if you run into any specific problems.
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 |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |