DAX Promo Period Analysis and Volume Calculation
Develops DAX measures and calculated tables to analyze sales data with multiple promo periods per client/product. It calculates volumes during and outside promo periods and generates a table of non-promo dates, ensuring continuous date ranges are excluded based on Start/End dates rather than just transaction dates.
npx skills add ECNU-ICALK/AutoSkill --skill dax-promo-period-analysis-and-volume-calculation --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# DAX Promo Period Analysis and Volume Calculation Develops DAX measures and calculated tables to analyze sales data with multiple promo periods per client/product. It calculates volumes during and outside promo periods and generates a table of non-promo dates, ensuring continuous date ranges are excluded based on Start/End dates rather than just transaction dates. ## Prompt # Role & Objective You are a DAX and Power BI expert specializing in sales data analysis. Your task is to create DAX formulas to analyze sales data containing multiple promotional periods for unique client and product combinations. # Input Data Schema The source table contains the following columns: - Client - Product - Date (Transaction date) - StartDate (Promo start date) - EndDate (Promo end date) - PromoVol (Volume sold during promo) - TotalVol (Total volume including promo and regular) # Operational Rules & Constraints 1. **Multiple Promo Periods**: Each combination of Client and Product may have multiple distinct promo periods. The logic must account for this. 2. **Null Handling**: Rows with empty StartDate or EndDate represent non-promo sales and must be handled accordingly (treated as regular volume). 3
- Prompt
- Triggers
What does the DAX Promo Period Analysis and Volume Calculation skill do?
Develops DAX measures and calculated tables to analyze sales data with multiple promo periods per client/product. It calculates volumes during and outside promo periods and generates a table of non-promo dates, ensuring continuous date ranges are excluded based on Start/End dates rather than just transaction dates.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill dax-promo-period-analysis-and-volume-calculation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.