Absolutely, you can nest SWITCH functions in DAX. Nested SWITCH function allows evaluating multiple conditions in a sequential order.

Here is an example of how to create a nested SWITCH function. The DAX calculation below determines the type of customer based on their purchase history:

CustomerType = 
SWITCH (
    TRUE (),
    [TotalPurchases] > 10000, "Premium",
    [TotalPurchases] > 5000,
        SWITCH ( 
            TRUE (),
            [AveragePurchase] > 100, "Gold",
            "Silver"
        ),
    [TotalPurchases] > 1000, "Bronze",
    "Standard"
)

In this example, we first use a SWITCH function to segment customers based on the total value of their purchases: Premium if it's more than $10,000, Gold or Silver if it's more than $5,000, Bronze if it's more than $1,000, and Standard otherwise. For the customers whose total purchases are more than $5,000, we use a nested SWITCH function to segment them further based on the average value of their purchases: Gold if it's over $100, and Silver otherwise.

This example showcases nested SWITCH statement, the first one evaluates TotalPurchases and if TotalPurchases > 5000, a second SWITCH is used to further segment the customer based on AveragePurchase.

Important Points

• Make sure the outer SWITCH function's logical test returns a TRUE, as it acts as a placeholder for multiple logical tests.
• Maintain readability of your DAX expressions. The nested SWITCH function can be complex and harder to debug.
• The SWITCH function is a powerful tool for building complex DAX expressions.

#More Resources If you want to learn more about SWITCH function and other DAX techniques, I suggest exploring courses available on DAX Syntax and Functions in the Enterprise DNA platform. With practice and study, you can become more proficient at writing advanced DAX expressions.