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.
Hi, I need to sort our customers into new, returning, multiple purchases in current financial year who bought in the previous year and new customers with multiple purchases in financial year. The dax calculation needs to be dynamic so that i can use it to determine sales amount and orders of product by the customers.
Financial year runs from May-April, so new customers who've acquired between these dates would need to be defined as a new customer.
Any help with this would be greatly appreciated!
Hello,
Check this article by SQLBI it may help you with your situation.
https://www.daxpatterns.com/new-and-returning-customers/
If I answered your question, please mark my post as solution, Appreciate your Kudos!
Proud to be a Super User! | |
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |