Communitygithub.com

David-Li0406/meta-skill-evloving

開發 DAX 量值與計算資料表,以分析具有多重促銷期間(每個客戶/產品)的銷售資料。計算促銷期間內外的銷量,並生成非促銷日期表,確保根據開始/結束日期排除連續日期範圍,而非僅依據交易日期。

meta-skill-evloving 是什麼?

此專業技能專注於使用 DAX(Data Analysis Expressions)分析具有多重促銷期間的銷售資料。對於每個獨特的客戶與產品組合,都可能存在多個不同的促銷時間段。該技能會建立相關的 DAX 量值與計算資料表,以精確計算促銷期間內(PromoVol 總和)與期間外(TotalVol 總和,扣除促銷時段的交易)的銷量。其關鍵設計在於「連續日期範圍排除」:當計算「促銷間隔」時,並非只排除實際有銷售交易的日期,而是根據每個促銷時段的 StartDate 至 EndDate,排除完整的連續日曆範圍。同時,對於 StartDate 或 EndDate 為空的資料列,會將其視為一般銷售(非促銷)。最終成果可直接用於堆疊長條圖等視覺化分析。支援的開發環境包括 Power BI Desktop 及任何可執行 DAX 的資料模型平台(如 Analysis Services、Excel Power Pivot)。

相容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/David-Li0406/meta-skill-evloving/tree/HEAD/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/dax-promo-period-analysis-and-volume-calculation

在你喜歡的 AI 中提問

開啟一個已預先載入此 Agent Skill 的新對話。

說明文件

DAX 促銷期間分析與銷量計算

開發 DAX 量值與計算資料表,以分析具有多重促銷期間(每個客戶/產品)的銷售資料。計算促銷期間內外的銷量,並生成非促銷日期表,確保根據開始/結束日期排除連續日期範圍,而非僅依據交易日期。

提示詞

角色與目標

您是 DAX 與 Power BI 專家,專精於銷售資料分析。您的任務是建立 DAX 公式,以分析包含多重促銷期間(針對獨特客戶與產品組合)的銷售資料。

輸入資料結構

來源資料表包含以下欄位:

  • Client
  • Product
  • Date (交易日期)
  • StartDate (促銷開始日期)
  • EndDate (促銷結束日期)
  • PromoVol (促銷期間銷售量)
  • TotalVol (總銷售量,含促銷與一般)

運作規則與限制

  1. 多重促銷期間:每個 Client 與 Product 的組合可能有多個不同的促銷期間。邏輯必須考慮此情況。
  2. 空值處理:StartDate 或 EndDate 為空的資料列代表非促銷銷售,必須依此處理(視為一般銷量)。
  3. 連續日期範圍排除:計算「促銷間隔」時,必須排除每個促銷期間 StartDate 至 EndDate 範圍內的所有日期。不要只排除實際有銷售交易發生的日期。排除必須涵蓋從 StartDate 到 EndDate 的完整連續日曆範圍。
  4. 銷量計算:
    • 計算促銷銷量:對落在促銷期間內的 PromoVol 加總。
    • 計算一般銷量:對落在促銷期間外的 TotalVol 加總。
  5. 視覺化:建議使用堆疊長條圖,以 Date 為 X 軸、Volume 為 Y 軸,並以 Client/Product 作為圖例或篩選條件來視覺化資料。

反模式

  • 在排除促銷期間時,不要只根據現有的交易日期進行篩選;您必須生成或參考 StartDate 與 EndDate 之間的完整日期範圍。
  • 不要假設每個客戶/產品只有一個促銷期間。
  • 不要將 StartDate/EndDate 為空的資料列視為促銷期間。

觸發詞

  • 在 DAX 中計算促銷間隔
  • DAX 促銷銷量 vs 一般銷量
  • 在 DAX 中從日曆排除連續日期範圍
  • 分析每個客戶產品的多重促銷期間
  • 包含開始與結束日期的 DAX 銷售資料

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

David-Li0406/meta-skill-evloving

Browser automation with persistent page state. Use when users ask to navigate websites, fill forms, take screenshots, extract web data, test web apps, or automate browser workflows. Trigger phrases include "go to [url]", "click on", "fill out the form", "take a screenshot", "scrape", "automate", "test the website", "log into", or any browser interaction request.

David-Li0406/meta-skill-evloving

Create technical diagrams using Mermaid syntax for architecture, sequences, ERDs, flowcharts, and state machines. Use for visualizing system design, data flows, and processes. Triggers: diagram, mermaid, architecture diagram, sequence diagram, flowchart, ERD, entity relationship, state diagram, C4 model, component diagram, visualize, draw.

David-Li0406/meta-skill-evloving

Comprehensive document creation, editing, and analysis with support for tracked changes, comments, formatting preservation, and text extraction. When Claude needs to work with professional documents (.docx files) for: (1) Creating new documents, (2) Modifying or editing content, (3) Working with tracked changes, (4) Adding comments, or any other document tasks

David-Li0406/meta-skill-evloving

Complete color manipulation and green screen effects system. PROACTIVELY activate for: (1) Green screen/chromakey removal, (2) Color grading with LUTs, (3) Color correction (levels, curves, white balance), (4) Colorkey/color removal effects, (5) Hue/saturation manipulation, (6) Color space conversions (BT.709, BT.2020, HDR), (7) Color isolation effects, (8) Teal and orange look, (9) Vintage/film looks, (10) Color keying for transparency. Provides: chromakey and colorkey filters, LUT application (lut3d), curves and levels adjustment, color balance, selective color manipulation, color space handling, HDR tone mapping, professional color grading chains.

David-Li0406/meta-skill-evloving

Convert files and office documents to Markdown. Supports PDF, DOCX, PPTX, XLSX, images (with OCR), audio (with transcription), HTML, CSV, JSON, XML, ZIP, YouTube URLs, EPubs and more.

David-Li0406/meta-skill-evloving

Guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).

David-Li0406/meta-skill-evloving

Build with OpenAI's stateless APIs - Chat Completions (GPT-5, GPT-4o), Embeddings, Images (DALL-E 3), Audio (Whisper + TTS), and Moderation. Includes Node.js SDK and fetch-based approaches for Cloudflare Workers. Use when: implementing chat completions with GPT-5/GPT-4o, streaming responses with SSE, using function calling/tools, creating structured outputs with JSON schemas, generating embeddings for RAG (text-embedding-3-small/large), generating images with DALL-E 3, editing images with GPT-Image-1, transcribing audio with Whisper, synthesizing speech with TTS (11 voices), moderating content (11 safety categories), or troubleshooting rate limits (429), invalid API keys (401), function calling failures, streaming parse errors, embeddings dimension mismatches, or token limit exceeded.

David-Li0406/meta-skill-evloving

Comprehensive PDF manipulation toolkit for extracting text and tables, creating new PDFs, merging/splitting documents, and handling forms. When Claude needs to fill in a PDF form or programmatically process, generate, or analyze PDF documents at scale.

David-Li0406/meta-skill-evloving

Presentation creation, editing, and analysis. When Claude needs to work with presentations (.pptx files) for: (1) Creating new presentations, (2) Modifying or editing content, (3) Working with layouts, (4) Adding comments or speaker notes, or any other presentation tasks

David-Li0406/meta-skill-evloving

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

David-Li0406/meta-skill-evloving

Download YouTube videos with customizable quality and format options. Use this skill when the user asks to download, save, or grab YouTube videos. Supports various quality settings (best, 1080p, 720p, 480p, 360p), multiple formats (mp4, webm, mkv), and audio-only downloads as MP3.

David-Li0406/meta-skill-evloving

Best practices for Remotion - Video creation in React

David-Li0406/meta-skill-evloving

Provides bidirectional translation (Chinese/English), grammar checking, and sentence polishing. Supports specific tense constraints, context-aware tone adjustment, and natural expression optimization. Outputs direct text without formatting.

David-Li0406/meta-skill-evloving

指导如何通过自定义注解(如@Unicom)标识Dubbo接口,利用BeanDefinitionRegistryPostProcessor在启动时扫描并动态注册ReferenceBean,实现RPC调用的封装。

David-Li0406/meta-skill-evloving

生成Python脚本,利用FFmpeg将图片序列按3x3布局合并,或将合并图拆分。要求使用subprocess模块执行命令,并支持用户交互式输入路径。

David-Li0406/meta-skill-evloving

SOP for extracting and analyzing promotional activity details, handling time formatting, location mapping, payment logic, and step-by-step process validation.

David-Li0406/meta-skill-evloving

Specializes in creating TikTok short video scripts using an anthropomorphic 'Chef' perspective to explain wildlife food chains and survival environments, utilizing real field footage.

David-Li0406/meta-skill-evloving

针对TikTok平台,以拟人化视角(如动物作为厨师)创作系列短视频脚本。重点介绍野生动物、食物链及生态环境,要求使用野外实拍素材,风格幽默且具有教育意义。

David-Li0406/meta-skill-evloving

Generates KWL (Know, Want to know, Learned) charts for educational videos, specifically BrainPOP, using simple 7th-grade language and short, concise bullet points.

David-Li0406/meta-skill-evloving

Tracks complex, multi-session work using the Beads issue tracker and dependency graphs, and provides persistent memory that survives conversation compaction. Use when work spans multiple sessions, has complex dependencies, or needs persistent context across compaction cycles. Trigger with phrases like "create task for", "what's ready to work on", "show task", "track this work", "what's blocking", or "update status".

相關技能