Communitygithub.com

David-Li0406/meta-skill-evloving

开发DAX度量值和计算表,分析具有每个客户/产品多个促销周期的销售数据。它计算促销期间内外的销量,并生成非促销日期表,确保根据开始/结束日期排除完整的日期范围,而不仅仅是交易日期。

meta-skill-evloving 是什么?

该技能旨在帮助DAX和Power BI专家分析包含多个促销周期的销售数据。它根据客户和产品的独特组合,处理多个促销时段,并精确计算促销期间内外的销量。核心功能包括:通过求和PromoVol计算促销销量,以及通过求和TotalVol并排除促销日期范围来计算常规销量。关键是,在排除促销日期时,技能要求排除从StartDate到EndDate的完整连续日期范围,而不仅仅是存在交易记录的日期。它还处理空值(将空StartDate/EndDate视为非促销销售),并建议使用堆积柱状图进行数据可视化。此技能适用于Claude Code、Cursor、Codex等AI代理平台,其详细说明文档(SKILL.md)提供了完整的DAX公式开发指导。

兼容平台~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公式,这些促销周期针对唯一的客户和产品组合。

输入数据模式

源表包含以下列:

  • 客户
  • 产品
  • 日期(交易日期)
  • 开始日期(促销开始日期)
  • 结束日期(促销结束日期)
  • 促销销量(促销期间销量)
  • 总销量(总销量,包括促销和常规)

操作规则与约束

  1. 多个促销周期:每个客户和产品的组合可能有多个不同的促销周期。逻辑必须考虑到这一点。
  2. 空值处理:开始日期或结束日期为空的行代表非促销销售,应相应处理(视为常规销量)。
  3. 连续日期范围排除:在计算“促销间隔期”时,必须排除每个促销周期中由开始日期和结束日期定义的范围内的所有日期。不要仅排除发生销售交易的具体日期。排除必须覆盖从开始日期到结束日期的完整连续日历范围。
  4. 销量计算:
    • 通过求和落在促销期间内的促销销量来计算促销销量。
    • 通过求和落在促销期间外的总销量来计算常规销量。
  5. 可视化:建议使用堆积柱状图,x轴为日期,y轴为销量,并使用客户/产品作为图例或筛选器来可视化数据。

反模式

  • 在排除促销期间时,不要仅根据现有交易日期进行筛选;必须生成或引用的开始日期和结束日期之间的完整日期范围。
  • 不要假设每个客户/产品只有一个促销周期。
  • 不要将开始日期/结束日期为空的行视为促销周期。

触发器

  • 计算DAX中促销间隔期
  • DAX促销销量与常规销量对比
  • 在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".

相关技能