counting new customers

[sgintowt]

Hello,

I'm going to calculate new customers and i have problem with formula dax. For example i have 3 columns with id, sale date and sale.

I created it, but it doesn't work. Please help.

New customers =

VAR currdate = max(Dates[Date])

VAR salesthisperiod = [Sales]

VAR customers =

ADDCOLUMNS(AccountsPerformanceReports,"Sales Until Now", [Sales], "Running Total Sales", AccountsPerformanceReports[Running Total Sales])

VAR newcustomers =

FILTER(customers,[Running Total Sales] = [Sales Until Now] &&[Sales Until Now] >0)

return

COUNTROWS(newcustomers)

Sales = SUM(AccountsPerformanceReports[Wydatki])

Running Total Sales =

VAR currdate = MAX(Dates[Date])

RETURN

CALCULATE(

[Sales],

FILTER(

ALL(Dates[Date]), Dates[Date] <= currdate)

)

[v-stephen-msft]

Hi @sgintowt ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with some dummy data and expected results.

Best Regards,
Stephen Tao

[sgintowt]

I'll check it, thank you!

[Greg_Deckler · Accepted solution]

@sgintowt Check this out: https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/m-p/168297#M13

Also, I have similar customer formulas in Chapter 6 of my DAX Cookbook: PacktPublishing/DAX-Cookbook: DAX Cookbook, Published by Packt (github.com)