Forum Discussion
hellind
7 years agoFrequent Visitor
Sales from Existing Customers purchasing first-time products + Sales from Existing Customers purchas
Current Year Sales = Sales from New Customers + Sales from Existing Customers purchasing first-time products + Sales from Existing Customers purchasing repeat products
Standard Data Model
Fact: Sales
DImension: Products, Customers, Dates
1. Create a Calculated Column "New/Existing" in Customers table. "New" if it has purchased this year but not last year. "Existing" if it has purchased both years. THis is pretty straight forward.
2. How do I go about creating a measure/column/any-solution that is "First-time ProductSales" and "Repeat Product Sales"
1 Reply
- AnonymousNot applicable
Hi hellind ,
I'd like some sample data with expected result to help us clarify your request and do test on coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng