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 ,
If you’ve gone through the shared responses and reference links, and they helped solve your issue, please mark the most helpful reply as the Accepted Solution. It really helps others in the community who might be facing the same kind of problem.

Thank You.