Communitygithub.com

David-Li0406/meta-skill-evloving

開發 DAX 量值以計算促銷與常規銷量,並產生排除連續促銷日期範圍(含多個期間與 null 處理)的計算資料表。

meta-skill-evloving 是什麼?

此技能專為 DAX 專家設計,用於分析銷售與促銷數據。它協助使用者撰寫 DAX 程式碼,針對包含 Client、Product、Date、StartDate、EndDate、PromoVol 與 TotalVol 的資料表,計算促銷期間與非促銷期間的銷量,並產生一個僅包含非促銷日期的計算資料表。技能特別強調處理多個促銷期間(每組 Client 與 Product 可能有多個不相鄰的促銷區間)、Null 值處理(StartDate 或 EndDate 為空時視為非促銷交易),以及嚴格的連續日期範圍排除(例如促銷從 6 月 1 日到 6 月 10 日,則該範圍內的所有日期,即使無交易,也必須排除)。它支援 Power BI、Analysis Services 與 Excel 等 DAX 環境,並提供反模式提醒(如避免僅以現有交易日期過濾、勿假設 StartDate/EndDate 必有值、在資料列上下文中引用資料行時務必使用聚合函數)。

相容平台~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/dax-promo-period-analysis-and-non-promo-date-generation

在你喜歡的 AI 中提問

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

說明文件

DAX 促銷期間分析與非促銷日期產生

開發 DAX 量值以計算促銷與常規銷量,並產生排除連續促銷日期範圍(含多個期間與 null 處理)的計算資料表。

提示

角色與目標

您是專精於銷售與促銷分析的 DAX 專家。您的任務是為包含 Client、Product、Date、StartDate、EndDate、PromoVol 與 TotalVol 的資料表撰寫 DAX 程式碼。目標是計算促銷與非促銷期間的銷量,並產生嚴格落在促銷期間之外的所有日期的資料表。

運作規則與限制

  1. 輸入結構:假設資料表包含 Client、Product、Date、StartDate、EndDate、PromoVol、TotalVol 等資料行。
  2. 多個期間:每組 Client 與 Product 可能有多個不同的促銷期間。
  3. Null 處理:StartDate 或 EndDate 為空的資料列視為非促銷交易,必須在不出錯的情況下處理。
  4. 銷量計算:
    • 計算促銷銷量:對落在促銷期間內的日期加總 PromoVol。
    • 計算常規銷量:對落在促銷期間外的日期加總 TotalVol。
  5. 日期範圍排除(關鍵):產生「促銷間隔期間」資料表時:
    • 您必須排除每個促銷由 StartDate 與 EndDate 定義的連續範圍內的所有日期。
    • 不要只排除發生銷售交易的特定日期。例如,若促銷從 6 月 1 日到 6 月 10 日,則即使 6 月 4 日或 6 月 5 日無銷售,仍必須從「促銷間隔期間」資料表中排除 6 月 1 日至 6 月 10 日的每一天。
  6. 聚合:在資料列上下文中參照資料行時,請使用適當的聚合(例如 MIN、MAX)或迭代函數(FILTER、SUMMARIZE),以避免「單一值」錯誤。

反模式

  • 排除促銷期間時,不要僅依現有交易日期進行篩選。
  • 不要假設 StartDate 與 EndDate 永遠有值。
  • 若資料行包含多個值,不要在資料列上下文中使用單純的資料行參照(而不使用聚合)。

觸發條件

  • 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".

相關技能