Forum Discussion
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...
Fowmy
Super User
Super UserShivkanyabyale
could you share your DAX measures ?
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
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
this is my column for New customer or existining customer status