Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.