📊 What You’ll Learn:

📈 How to analyze year-over-year Sales, Profit, Orders, and Returns growth

🌍 Region-wise performance breakdown: West, East, Central, South

🛍️ Segment-wise sales contribution: Corporate, Consumer, Home Office

🧾 Category-wise sales: Technology, Furniture, Office Supplies

🗺️ Sales mapping by Country/Region (Canada vs United States)

🔄 Visual storytelling using trend lines, bar charts, pie charts, and maps

DAX Codes Used in the project are as follows:

DateTable = 
CALENDAR(DATE(2021, 1, 1), DATE(2025, 12, 31))

CY_Flag = IF(YEAR('DateTable'[Date]) = 2024, 1, 0)

PY Sales = 
CALCULATE(
    SUM(Orders[Sales]),
    'DateTable'[Year] = YEAR(TODAY())-2
)

YoY% = 
DIVIDE(
    [CY Sales] - [PY Sales],
    [PY Sales],
    0
)

YoY Label = 
VAR Change = [YoY%]
RETURN 
IF(Change >= 0, "▲ ", "▼ ") & FORMAT(Change, "0.00%")

CY Orders = 
CALCULATE(
    DISTINCTCOUNT(Orders[Order ID]),
    'DateTable'[CY_Flag] = 1
)

ReturnedOrdersWithDates = 
ADDCOLUMNS(
    DISTINCT(
        FILTER(Returns, Returns[Returned] = "Yes")
    ),
    "Order Date", LOOKUPVALUE(Orders[Order Date], Orders[Order ID], Returns[Order ID])
)