📊 Power BI DAX: Current Year YTD vs Previous Year YTD 🗓️

 Year-To-Date (YTD) measures help compare current performance with the previous year, enabling better trend analysis.

---

📆 What is YTD?

🔹 Current YTD: Cumulative total from Jan 1 to today
🔹 Previous YTD: Same range, but for last year

---

🧮 DAX: Current Year YTD

Dax

Sales YTD = 
TOTALYTD(
    SUM(Sales[Amount]),
    'Date'[Date]
)

---

🔙 DAX: Previous Year YTD

Dax

Sales PY YTD = 
CALCULATE(
    [Sales YTD],
    SAMEPERIODLASTYEAR('Date'[Date])
)

---

✅ Best Practices

📌 Use a marked Date Table
📉 Great for trend comparison
📊 Works well in financial & sales dashboards