New Customers with order over a certain value - shopify data

Hi JackEnviro,

The formula below assumes that Created Date is column is when an order was created so any row that matches the earliest created date by customer and where Full Order  = Full is the New Order.

New Order? = 
VAR FirstOrderDate =
    CALCULATE (
        MIN ( ShopifyValues[Created Date ] ),
        ALLEXCEPT ( ShopifyValues, ShopifyValues[Customer ID] ),
        ShopifyValues[Customer ID] = EARLIER ( ShopifyValues[Customer ID] )
    )
RETURN
    IF (
        ShopifyValues[Full Order] = "Part",
        "N/A",
        IF (
            FirstOrderDate = ShopifyValues[Created Date ]
                && ShopifyValues[Full Order] = "Full",
            "New",
            "Return"
        )
    )