跳到主要内容
PromptDaily每日精选并验证的 AI 提示词
日常生活

DAX终端

DAX Terminal

测试模型:
GPT-4o
有效性评分:
75/100
提示词归档

中文版本

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.

填入内容并运行

将在新标签页打开并已填入提示词。可能需要先登录该服务。

如何使用此提示词

  • 发送前,请将方括号中的内容替换为你自己的信息。
  • 不同模型的结果会有差异。若输出不理想,可换一个模型或补充一个具体示例。
  • 请将提示词放在一条消息中发送。分多次发送会削弱指令效果。

日常生活提示词