Forum Discussion
Solved
DAX help calculating Repeat Customers
Hi, I’m working in Power BI and trying to create a DAX formula to classify purchasers as either Repeat Customers or Single Customers based on their Customer ID and the dates they made purchases. Fo...
hello nascarfan22
i am using your sample data above, please try if this match to your need.
1. create a calculated column to check single or repeat.
Check =
var _Count =
COUNTX(
FILTER(
'Table',
'Table'[Customer ID]=EARLIER('Table'[Customer ID])&&
'Table'[Sales Date]<>EARLIER('Table'[Sales Date])
),
'Table'[Customer ID]
)
Return
IF(
_Count=1,
"Repeat",
"Single"
)2. create two measures for single and repeat
Single =
CALCULATE(
DISTINCTCOUNT('Table'[Customer ID]),
'Table'[Check]="Single"
)Repeat =
CALCULATE(
DISTINCTCOUNT('Table'[Customer ID]),
'Table'[Check]="Repeat"
)Hope this will help.Thank you.
V-yubandi-msft
Community Support
Community SupportHi nascarfan22 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.