Separates DAX data-fetching from TypeScript presentation. Guides when to use DAX vs. TypeScript vs. Vega-Lite for aggregation, total rows, FORMAT(), SELECTCOLUMNS, BLANK handling, filtering, multi-grain queries, and format strings.
Install
npx skills add microsoft/rayfin --skill query-designnpx skills add microsoft/rayfin --skill query-design -a claude-code -gnpx skills add microsoft/rayfin --skill query-design -a codex -ggemini skills install https://github.com/microsoft/rayfin.git --path samples/data-app/.agents/skills/query-designgh skill install microsoft/rayfin query-designgit clone --depth 1 https://github.com/microsoft/rayfin /tmp/microsoft__rayfin
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/microsoft__rayfin/samples/data-app/.agents/skills/query-design ~/.claude/skills/query-design # Claude Code
cp -R /tmp/microsoft__rayfin/samples/data-app/.agents/skills/query-design ~/.agents/skills/query-design # Codex, Cursor, Gemini CLI, Copilot, OpenCode