Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Identify new Customers

Hi,   I have a list of sales by customer and by week. I'd like to identify how many new customers I have each week. In my database, I have data for last 3 years, howerver, I want to apply the formu...
Need Help
Show and Tell
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could also use DAX to create a new column.

Column =
VAR a =
    RANKX (
        FILTER (
            'Table',
            'Table'[Customer] = EARLIER ( 'Table'[Customer] )
                && 'Table'[Week] >= 12
        ),
        'Table'[Week],
        ,
        ASC,
        DENSE
    )
RETURN
    IF ( a = 1, "yes", "no" )

Here is the result.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-eachen-msft  Thanks.
This works but it takes the full database (all 3 years). I'd like to apply this only for this year.
I have applied this as a filter, but it still didn't work as expected.

Below is an example of how the visual is filtered


Thanks.