All authors
Claude Skills by CSalcedoDataBI
github.com/CSalcedoDataBI15 skills0 installs30 views
- M Custom FunctionsUse when writing a custom Power Query M function — typed and optional parameters, return types, recursion with @, functions that take functions, attaching Documentation metadata with Value.ReplaceType so the function shows a description and examples in the editor, or turning a query into a reusable function. Triggers on "M custom function", "Power Query function parameters", "optional parameter M", "Value.ReplaceType", "document my function", "Documentation.Name", "recursive function Power Qu...Votes: 0GitHub stars: 4
- M FoldingUse when a Power Query M step may or may not fold to the data source — deciding whether a transformation is pushed down as native SQL or evaluated locally, finding which step breaks folding, reading the step folding indicators or View Native Query, using Value.NativeQuery with EnableFolding, or designing a query so it stays foldable for incremental refresh. Triggers on "query folding", "does this fold", "breaks folding", "native query", "Value.NativeQuery", "EnableFolding", "refresh is slow P...Votes: 0GitHub stars: 4
- M IterationUse when a Power Query M task needs looping or state across rows — List.Generate, List.Accumulate, running totals, paginating a REST API until the last page, Table.Buffer or List.Buffer to stop repeated evaluation, GroupKind.Local for sorted groups, or deciding between these for performance. Triggers on "loop in Power Query", "List.Generate", "List.Accumulate", "pagination Power Query", "running total M", "Table.Buffer", "List.Buffer", "GroupKind.Local", "iterate API pages".Votes: 0GitHub stars: 4
- M FeedbackUse when, while working with Power Query M in any project, m-reference proves wrong or incomplete - a card or note contradicts what the engine returned, a trap is missing, a real name is reported as nonexistent - or the user asks to report a gap to powerquery-m-for-agents. Drafts a sanitized issue for its public repo and files it only after the user approves the text. Triggers on "report this to powerquery-m-for-agents", "m-reference is wrong", "add this trap to the M reference", "reporta est...Votes: 0GitHub stars: 4
- M ReferenceUse when you need to know whether a Power Query M library function exists, its exact signature and parameter types, what it returns, which hosts have it (Power BI Desktop, Excel, Dataflows Gen2), or which of several similar functions to reach for — and for the M language itself when no single function is in question, such as let/in, each and the underscore, records, lists and tables, types and metadata, try/otherwise/catch, lazy evaluation and streaming. Triggers on "what does X do in M", "Po...Votes: 0GitHub stars: 4
- Decisions**Date:** 2026-10-05 **Status:** decided by the owner **Affects:** the [PBIP builder proposal](../proposals/2026-10-05-pbip-builder-system-prompt.md), the `dax-reference` description, `evals/cases.yaml` ---Votes: 0GitHub stars: 3
- Plans> **For agentic workers:** REQUIRED SUB-SKILL: Use superpowers:subagent-driven-development (recommended) or superpowers:executing-plans to implement this plan task-by-task. Steps use checkbox (`- [ ]`) syntax for tracking. **Goal:** Add a fifth skill, `dax-lib-install`, that fetches a third-party DAX UDF `dax-lib` already found in the daxlib.org index, checks its license, installs it against a real model, proves it runs, and leaves it attributed — replacing `dax-lib`'s current "point at the i...Votes: 0GitHub stars: 3
- Dax FeedbackUse when this plugin proves wrong or incomplete while working in any project: a card or field note the engine contradicts, a wrong signature or appliesTo, an example that does not reproduce, a gap you had to measure or guess, or the user says \"report this to dax-for-agents\" / \"la ficha está mal\". Files one sanitized issue on its public repo, after showing it to the user.Votes: 0GitHub stars: 3
- Dax Lib InstallUse when installing a DAX UDF from daxlib.org into a live model or PBIP folder after dax-lib found it. Fetches the function body with gh api, asks before writing, records author, license and source on the function, installs it, and test-runs it. Triggers on "install this UDF", "bring in the daxlib function", "add the daxlib function to my model", "vendor this DAX package".Votes: 0GitHub stars: 3
- Dax LibUse when about to write a DAX UDF, to check whether one is already published on DAX Lib (daxlib.org) — moving averages, format strings, SVG visuals, KPI/variance, RFM/ABC classification, unit conversion, model metadata, sample data. Offline index — what exists, who wrote it, where to get it. Triggers on "is there a UDF for", "existing DAX UDF", "daxlib", "DAX Lib package".Votes: 0GitHub stars: 3
- Dax ReferenceUse when you need what a built-in DAX function does — signature, where it is legal (measure, calculated column or table, visual calculation), whether it is deprecated, which of similar functions to pick — or a DAX concept — evaluation, filter and row context, context transition, EVALUATE/DEFINE, BLANK, operators. Also when writing DAX measures, including inside a PBIP or TMDL build, or when asked for an example PBIP to open. Triggers on "what does X do in DAX", "which DAX function", "differen...Votes: 0GitHub stars: 3
- Dax Udf AuthoringUse when writing your own DAX user-defined function (FUNCTION) — parameter types (AnyRef, ColumnRef, MeasureRef, CalendarRef), VAL vs EXPR, TABLEOF/NAMEOF, optional parameters, naming, and known parser bugs. For existing UDFs use dax-lib; for built-ins, dax-reference. Triggers on "write a DAX UDF", "define a DAX FUNCTION", "ANYREF", "VAL vs EXPR", "TABLEOF", "optional parameter in a UDF".Votes: 0GitHub stars: 3
- Dax Window FunctionsUse when writing a DAX measure with WINDOW, OFFSET, INDEX, RANK, ROWNUMBER, MOVINGAVERAGE or RUNNINGSUM (ORDERBY/PARTITIONBY/MATCHBY) — rolling averages, running totals, prior-period rows, ranking within a partition. Covers ABS vs REL and the ALLSELECTED default that silently returns blanks. Triggers on "rolling average", "running total", "trailing N", "OFFSET returns blank", "ABS vs REL", "PARTITIONBY".Votes: 0GitHub stars: 3
- GradersNo description providedVotes: 0GitHub stars: 2
- Leer Facturas UblUse when the user has UBL 2.1 electronic invoices — DIAN Colombia XML/ZIP (incl. AttachedDocument) or PEPPOL / EN 16931 Invoice, CreditNote, DebitNote — or a folder of invoice .xml/.zip files, and wants a Power BI star schema (Parquet/CSV) or totals, IVA/VAT, credit-note netting or per-supplier figures. Runs the pinned ubl-star CLI, never a hand-written XML parser. Triggers: «factura electrónica», «XML de la DIAN», «facturas a Power BI», «nota crédito», «CUFE», «UBL», «PEPPOL», «e-invoice», «...Votes: 0GitHub stars: 2