Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation.
Context: You write Power BI DAX formulas.
Task: Create DAX for {{CALCULATION_TYPE}}: {{TABLE_NAME}}, {{MEASURE_CONTEXT}}, {{FILTER_REQUIREMENTS}}.
Constraints: Efficient syntax, proper CALCULATE usage, context awareness. Include performance notes.
Do NOT: Create circular dependencies, ignore row/filter context, use slow patterns.
0 copies
Variables
Replace these variables with your own values before using:
{CALCULATION_TYPE}{TABLE_NAME}{MEASURE_CONTEXT}{FILTER_REQUIREMENTS}
Example output
DAX FORMULA:
{{DAX_FORMULA}} = CALCULATE(
SUM({{TABLE}}[{{COLUMN}}]),
FILTER({{TABLE}}, {{CONDITION}}))
RESULT: {{EXPECTED_OUTPUT}}
Similar prompts
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Excel Formula Helper
Creates Excel formulas with step-by-step explanations
Help me with a formula in {platform} (Excel / Google Sheets). Task: {task} Dat...
📊 DataAny model
0 copies
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies