skills.rest
accelerate-data
accelerate-dataOFFICIAL
Explore all skills by this author →
WebsiteGitHub

authoring-dax-measures

Generate TMDL-formatted DAX measures for Fabric semantic models.

Updated Apr 18, 2026
Search Tags:#patterns#fabric#kpi#dax#semantic-model#time-intelligence#tmdl
One-click install
npx skills add https://github.com/accelerate-data/fabric-semantic-model --skill authoring-dax-measures
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: authoring-dax-measures
Source: https://github.com/accelerate-data/fabric-semantic-model/tree/main/skills/authoring-dax-measures
Command: npx skills add https://github.com/accelerate-data/fabric-semantic-model --skill authoring-dax-measures

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Authors rely on ad-hoc patterns and inconsistent naming when creating DAX measures for Fabric semantic models, leading to maintenance burdens and potential performance issues. This skill provides a centralized library of proven DAX/TMDL patterns (Time Intelligence, Semi-Additive, Parent-Child, and KPI measures) and a guided workflow to scaffold reliable measures that integrate with dbt-first project context.

Core Features & Use Cases

  • Pattern library of DAX/TMDL measures covering Time Intelligence, Semi-Additive, Parent-Child, and common KPIs.
  • Workflow to add measures to existing TMDL models, respecting date tables, displayFolder, and formatString conventions.
  • Real-world scenario: extend a model with YTD, YoY, and revenue KPIs across multiple calendars.

Quick Start

Provide a natural-language description of the measure you want and the skill will generate a ready-to-paste TMDL pattern.

Frequently Asked Questions about authoring-dax-measures

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create DAX measures for Fabric semantic models using TMDL?▼

Create DAX measures for Fabric semantic models by providing a natural-language description to generate ready-to-paste TMDL patterns. This enforces naming conventions, scaffolding, and integration best practices while applying formatting and displayFolder properties automatically.

What is the best way to scaffold time intelligence and KPI measures in a dbt-first context?▼

Scaffolding time intelligence and KPI measures in a dbt-first context relies on a centralized library of proven DAX/TMDL patterns. The workflow generates properly formatted measures that respect date tables and integrate with your existing dbt project context.

Does this DAX pattern library support semi-additive measures and parent-child hierarchies?▼

Yes, the DAX pattern library supports semi-additive measures and parent-child hierarchies. It provides a guided workflow to add these specific measure types to existing TMDL models while maintaining displayFolder and formatString conventions.

How do I add YTD and YoY measures across multiple calendars in TMDL?▼

Add YTD and YoY measures across multiple calendars by extending your model with the Time Intelligence DAX/TMDL patterns. The workflow respects your configured date tables to generate accurate time-intelligence calculations for varied calendar structures.

Why should I use standardized TMDL patterns instead of ad-hoc DAX measure creation?▼

Standardized TMDL patterns prevent the maintenance burdens and performance issues caused by ad-hoc DAX measure creation. They ensure consistent naming, proper formatting, and reliable integration best practices across your Fabric semantic models.

Related Skills

Explore More Data & Analytics Skills→
accelerate-dataaccelerate-data

validating-semantic-model

Validate Fabric semantic models for structural, relationship, and measure issues.

Official
Advanced
jonathan-papjonathan-pap

measures

Design Power BI DAX measure layers with TMDL wrappers and naming conventions.

Community
Advanced
wardawgmalviciouswardawgmalvicious
2

fabric-tmdl

Automate TMDL file creation for Fabric and Power BI semantic models.

Community
Advanced
marcelodfelmanmarcelodfelman

Power BI Modeling

Build and manage Power BI semantic models with pbi-cli.

Community
Advanced