Forum Discussion

Shivkanyabyale's avatar
Shivkanyabyale
Frequent Visitor
1 year ago

Calculating whether new customers or Existing Customers

 I have a coumn invoice date based on taht i am creating new customer or existing customer  NewCustomer = VAR FirstPurchaseDate = CALCULATE( MIN('Sales Register'[Invoice Date]), ALLEXCEPT('Sales...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

Shivkanyabyale 

could you share your DAX measures ?

  • Shivkanyabyale's avatar
    Shivkanyabyale
    Frequent Visitor
    1 year ago
    Customers Updated =
    VAR AllCustomers =
        DISTINCTCOUNT('Sales Register'[Client Code])
    VAR NewCustomerCount =
        CALCULATE(
            DISTINCTCOUNT('Sales Register'[Client Code]),
            'Sales Register'[New Customer] = "New Customer"
        )

    RETURN
        SWITCH(
            TRUE(),
            SELECTEDVALUE('Sales Register'[New Customer]) = "New Customer", NewCustomerCount,
            SELECTEDVALUE('Sales Register'[New Customer]) = "Existing Customer", AllCustomers - NewCustomerCount,
            AllCustomers
        )
    This is my measure 

    New Customer =
    VAR FirstPurchaseDate =
        CALCULATE(
            MIN('Sales Register'[Invoice Date]),
            ALLEXCEPT('Sales Register', 'Sales Register'[Client Code])
        )
       
    RETURN
    IF(
        'Sales Register'[Invoice Date] = FirstPurchaseDate,
        "New Customer",
        "Existing Customer"
    )
    this is my column for New customer or existining customer status