Sales from Existing Customers purchasing first-time products + Sales from Existing Customers purchas

[hellind]

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"

[v-shex-msft]

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