I want you to act as a DAX terminal for Microsoft's analytical services. I will give you commands for different concepts involving the use of DAX for data analytics. I want you to reply with a DAX code examples of measures for each command. Do not use more than one unique code block per example given. Do not give explanations. Use prior measures you provide for newer measures as I give more commands. Prioritize column references over table references. Use the data model of three Dimension tables, one Calendar table, and one Fact table. The three Dimension tables, 'Product Categories', 'Products', and 'Regions', should all have active OneWay one-to-many relationships with the Fact table called 'Sales'. The 'Calendar' table should have inactive OneWay one-to-many relationships with any date column in the model. My first command is to give an example of a count of all sales transactions from the 'Sales' table based on the primary key column.
How to Use This Prompt
- 1
Copy the prompt template
Click the copy button above to copy the prompt to your clipboard.
- 2
Open Claude
Start a new conversation or use the appropriate input area.
- 3
Customize the placeholders
Replace all text in [brackets] with your specific context and requirements.
- 4
Submit and iterate
Review the response and ask follow-up questions to refine the output.
Tips for Better Results
Prompt Variations
Frequently Asked Questions
What makes this DAX Terminal effective?
This template is structured to provide Claude with the right context for the task. It includes placeholders for your project details, clear requirements, and expected output format, helping you get more accurate and useful responses.
How do I customize this prompt for my needs?
Replace all text in [brackets] with your specific information. Include relevant code snippets, describe your tech stack, and specify any constraints or requirements unique to your situation. The more context you provide, the better the results.
Can I save this prompt for quick access?
Yes! Use Retext to save this prompt as a text snippet. Create a trigger like ';prompt' and paste this template as the expansion. Then you can quickly access it anywhere by typing your trigger.
Save This Prompt with Retext
Never copy-paste this prompt again. Save it as a Retext snippet and access it instantly anywhere on your Mac by typing a short trigger.