Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
Anyone know how to calculate active customer numbers. The active customer must to have at least 4 units sales every month.
Thank you.
Hi @dannyschool ,
You can check if this works
Quantity 1M =
CALCULATE (
SUM ( 'Table'[Purchase Quantity] ),
DATESINPERIOD (
'Calendar'[Date],
MAX ( 'Calendar'[Date] ),
-1,
MONTH
)
)
Active Customers =
VAR _activeCusts =
FILTER (
Customers,
[Quantity 1M] > 4
)
RETURN
COUNTROWS ( _activeCusts )
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @dannyschool
It could something like this:
MoreThan4 =
var _NofMonths = DISTINCTCOUNT(Data[Month])
var _4Units = calculate( DISTINCTCOUNT(Data[Month]), Data[Qty] >=4)
return If (_4Units>=_NofMonths, "Active", "Not Active")
@JustJan , refer if this can ehlp
https://community.powerbi.com/t5/Desktop/Churn-Rate-lost-Customer/m-p/1173754#M529196
https://blog.enterprisedna.co/new-vs-existing-customers-advanced-analytics-w-dax/
https://www.sqlbi.com/articles/computing-new-customers-in-dax/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |