Forum Discussion

nascarfan22's avatar
nascarfan22
Regular Visitor
1 year ago
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...
"CALCULATE"
"DAX "
"DAX " "DAX help" 'Need help'
"FILTER"
distinctcount
  • Irwan's avatar
    Irwan
    1 year ago

    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's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi nascarfan22 ,

Could you confirm if your issue has been resolved or if you're still facing challenges. If the solution worked for you, please consider marking it as the accepted solution so it can help other community members. If you're still experiencing issues, feel free to share the details.

 

Thank You.