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
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Check this code for a new column:

let
_customer = [Customer],
_currentWeek = [Week]
in
if _currentWeek = List.Min(Table.SelectRows(#"Changed Type", each [Customer] = _customer and [Week] >= 12)[Week]) then "Yes" else "No"

 

 

Just change the bold part for your last step name.