cancel
Showing results for
Did you mean:
Frequent Visitor

counting new customers

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.

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)
)
1 ACCEPTED SOLUTION
Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
3 REPLIES 3
Community Support

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

Frequent Visitor

I'll check it, thank you!

Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Announcements

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

Power BI May 2023 Update

Find out more about the May 2023 update.