Power BI- Essential Marketing DAX Measures

 

 Essential Marketing DAX Measures

1. Campaign ROI

Total Campaign Revenue = SUM(Marketing[Revenue])
Total Campaign Cost = SUM(Marketing[Cost])

Campaign ROI % = 
DIVIDE([Total Campaign Revenue] - [Total Campaign Cost], 

[Total Campaign Cost], 0)

Campaign ROI YTD = 
TOTALYTD([Campaign ROI %], DateTable[Date])

 Tracks profitability of campaigns over time.

---

2. Lead Generation

Total Leads = COUNTROWS(Leads)

Leads MTD = 
CALCULATE([Total Leads], DATESMTD(DateTable[Date]))

Leads YTD = 
TOTALYTD([Total Leads], DateTable[Date])

Leads LY = 
CALCULATE([Total Leads], SAMEPERIODLASTYEAR(DateTable[Date]))

 Shows lead volume trends month-to-date, year-to-date, and vs. last year.

---

3. Conversion Rate

Conversions = COUNTROWS(FILTER(Leads, Leads[Status] = "Converted"))

Conversion Rate % = 
DIVIDE([Conversions], [Total Leads], 0)

Conversion Rate YTD = 
TOTALYTD([Conversion Rate %], DateTable[Date])

Conversion Rate LY = 
CALCULATE([Conversion Rate %], SAMEPERIODLASTYEAR(DateTable[Date]))

 Measures funnel efficiency across time periods.

---

4. Cost per Lead (CPL)

Cost per Lead = 
DIVIDE([Total Campaign Cost], [Total Leads], 0)

CPL YTD = 
TOTALYTD([Cost per Lead], DateTable[Date])

CPL LY = 
CALCULATE([Cost per Lead], SAMEPERIODLASTYEAR(DateTable[Date]))

Helps optimize marketing spend efficiency.

---

5. Customer Engagement

Total Clicks = SUM(Engagement[Clicks])
Total Impressions = SUM(Engagement[Impressions])

CTR (Click-Through Rate) = 
DIVIDE([Total Clicks], [Total Impressions], 0)

CTR YTD = 
TOTALYTD([CTR], DateTable[Date])

CTR LY = 
CALCULATE([CTR], SAMEPERIODLASTYEAR(DateTable[Date]))

 Tracks engagement metrics across campaigns.

---

6. Customer Lifetime Value (CLV)

CLV = AVERAGEX(CustomerTable, CustomerTable[Revenue])

CLV YTD = 
TOTALYTD([CLV], DateTable[Date])

CLV LY = 
CALCULATE([CLV], SAMEPERIODLASTYEAR(DateTable[Date]))

 Shows long-term profitability of customers.

---

Takeaway

These measures give Marketing teams time-based insights into ROI, lead generation, conversion rates, CPL, engagement, and CLV. By layering date intelligence functions (DATESMTD, TOTALYTD, SAMEPERIODLASTYEAR), you can present monthly, quarterly, and yearly comparisons that help optimize campaigns and budgets.