Power BI DAX Formula Assistant
Build production-ready DAX formulas for Power BI
What You Can Do
You can write, optimize, and debug DAX formulas for Power BI models with confidence. This skill helps you construct complex measures, calculated columns, and relationships using DAX best practices, translate business logic into formula syntax, and refactor existing formulas for performance and clarity.
Features
Identifies syntax errors and suggests corrections before you deploy formulas
Generates context-aware DAX measures (SUM, CALCULATE, SUMPRODUCT) for common analytics scenarios
Recommends query-folding strategies and efficient DAX patterns to reduce model refresh times
Converts business requirements into working DAX formulas with explanations
Helps create calculated columns with proper data types and filter context awareness
Analyzes formula errors and provides step-by-step fixes
Simplifies complex formulas using variables (VAR) and nested function optimization
Generates YTD, MTD, and prior-period comparisons using TOTALYTD, DATEADD, and SAMEPERIODLASTYEAR
Example Output
Example 1: Sales Growth Measure
Sales Growth % =
VAR PreviousYearSales =
CALCULATE(
SUM(Sales[Amount]),
SAMEPERIODLASTYEAR(Date[Date])
)
RETURN
IF(PreviousYearSales = 0, BLANK(),
(SUM(Sales[Amount]) - PreviousYearSales) / PreviousYearSales
)
Example 2: Customer Segmentation Logic
Created a calculated column that tags customers as "High Value", "At Risk", or "Growth" based on purchase frequency, recency, and monetary value using nested IF and CALCULATE functions.
Example 3: Formula Optimization
Refactored a slow 8-line SUMPRODUCT formula into a 3-line CALCULATE measure, reducing model refresh time by 40% while maintaining identical results.
What's Included
- SKILL.md: Complete DAX formula reference with 50+ formula patterns
- Measure Templates: Pre-built formulas for sales, marketing, HR, and finance analytics
- Common Errors Checklist: Debugging guide for circular dependencies, blank values, and context issues
- DAX Style Guide: Formatting conventions and naming standards for readability
- Performance Optimization Workflow: Step-by-step guide to profile and refactor slow formulas
- Time Intelligence Reference: Gallery of YTD, QTD, MTD, and custom period formulas
Who It's For
- Business Analysts — Create accurate KPIs and business metrics without waiting for BI engineers
- Power BI Developers — Optimize model performance and refactor legacy formulas
- Financial Analysts — Build complex variance analysis and forecasting measures
- Data Analysts — Translate business logic into DAX for self-service analytics
- Excel power users — Transition formula skills from Excel to DAX/Power BI
Best For
- Building complex calculated measures for dashboards and reports
- Debugging formula errors and performance issues in existing models
- Optimizing DAX formulas for faster model refresh times
- Creating time-based analytics (YTD, rolling averages, prior-period comparisons)
- Implementing business logic that spans multiple tables (relationships and CALCULATE context)
You might also like
You'll analyze competitor positioning, market strategies, and business models to generate actionable competitive intelligence reports. This skill synthesizes public data, customer research, and market trends into structured competitive analysis that informs product strategy, pricing, and go-to-market decisions. Get clear competitive advantages, threat assessments, and market opportunity summaries without hours of manual research.
by lurenyang418
This skill transforms raw competitive data—customer reviews, pricing structures, feature lists, and market reports—into structured, actionable intelligence reports. It creates competitive positioning matrices that reveal market gaps, pricing strategies, and feature differentiation at a glance. Get the strategic insights you need to inform product roadmaps, refine positioning, and make confident go-to-market decisions.
by lurenyang418
You develop comprehensive go-to-market strategies by analyzing your target market, creating detailed buyer personas, and mapping buying journeys. You then build multi-channel campaign blueprints with positioning frameworks, messaging matrices, and sales enablement assets tailored to your specific buyers and launch goals. This skill transforms product launches from guesswork into data-informed strategies with clear timelines, channel recommendations, and success metrics.
by lurenyang418
You can create comprehensive, data-driven go-to-market strategies that align your enterprise product with market realities, competitive landscapes, and internal capabilities. This skill guides you through market analysis, positioning, timeline creation, pricing strategy, and launch readiness assessments—delivering actionable roadmaps that reduce launch risk and accelerate time-to-market for complex B2B initiatives.
by lurenyang418
This skill helps you develop comprehensive go-to-market strategies that accelerate market entry and revenue generation for enterprise products. You'll conduct competitive landscape analysis, design multi-channel distribution models, allocate resources strategically, and create detailed launch roadmaps that align sales, marketing, and product teams. The result is a strategic blueprint that reduces market-entry risk and increases go-to-market velocity.
by lurenyang418
Transform raw qualitative data—interviews, surveys, focus groups, open-ended feedback—into structured themes and actionable insights. Claude systematically codes your data using established frameworks (Braun & Clarke, grounded theory, phenomenology), identifies patterns across respondents, and synthesizes findings into clear, evidence-based recommendations. You'll go from hundreds of transcript pages to organized themes with illustrative quotes in minutes.
by lurenyang418
Build complete B2C campaign launch plans from positioning through execution. You'll segment audiences based on behavior and value, architect cohesive messaging for each segment, design optimal channel mixes, and establish measurable success metrics tied to business outcomes. Get a ready-to-execute campaign blueprint that coordinates positioning, creative, channels, and performance tracking.
by lurenyang418
You upload interview transcripts, survey responses, or focus group data, and this skill systematically extracts themes, patterns, and relationships using proven thematic coding frameworks. It moves beyond raw data to deliver actionable strategic insights, complete with prioritization and visualization recommendations. The result is a structured, evidence-based foundation for decision-making.
by lurenyang418