dax-udf

Define reusable DAX UDFs with createOrReplace wrappers for Power BI semantic models.

2|Updated May 1, 2026
One-click install
npx skills add https://github.com/jonathan-pap/PowerBI-Claude-Design --skill dax-udf
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dax-udf
Source: https://github.com/jonathan-pap/PowerBI-Claude-Design/tree/main/dax-udf
Command: npx skills add https://github.com/jonathan-pap/PowerBI-Claude-Design --skill dax-udf

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DAX UDFs let you define reusable, typed functions that can be invoked from measures and calculated columns, reducing boilerplate and ensuring consistent patterns across your Power BI models.

Core Features & Use Cases

  • Type-safe function definitions with explicit parameter subtypes and modes (Val, Expr, AnyRef).
  • Centralized UDFs deployed with a createOrReplace wrapper for deterministic updates.
  • Reusability across measures, time-intelligence patterns, and complex calculations within semantic models.
  • Supports scalar, table, or reference returns to accommodate varied use cases.

Quick Start

Create a simple DAX UDF named 'CircleArea' that computes the area of a circle from a numeric radius.

Frequently Asked Questions about dax-udf

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

FAQPage Schema
How do I create reusable DAX functions in Power BI semantic models?

Reusable DAX functions are created using UDF definitions with a createOrReplace wrapper, enforcing type safety and reducing boilerplate across Power BI semantic models. You define typed functions with explicit parameter subtypes and modes like Val or Expr for deterministic updates.

What are DAX UDF parameter modes and how do they work?

DAX UDF parameter modes include Val and Expr, along with AnyRef references for flexible function inputs. These modes define how arguments are evaluated and passed within semantic models, ensuring type-safe function definitions for measures and calculated columns.

Can I use DAX UDFs for time-intelligence patterns and complex calculations?

Yes, DAX UDFs support reusability across measures, time-intelligence patterns, and complex calculations within semantic models. They accommodate scalar, table, or reference returns to handle varied analytical use cases consistently.

What is the best way to enforce type safety in Power BI DAX measures?

The best way to enforce type safety in DAX measures is using UDF definitions with explicit parameter subtypes and modes. This approach centralizes logic with a createOrReplace wrapper, ensuring consistent, typed patterns across your semantic model.

Does the dax-udf Skill require external dependencies to deploy?

No, the dax-udf Skill has no external dependencies. It deploys DAX UDFs with a createOrReplace wrapper directly into semantic models, and optionally supports directories for scripts, references, and assets to organize your codebase.