all publishers

CSalcedoDataBI

@csalcedodatabi source repo

8 published skills

  1. ▌
    Dax Lib · csalcedodatabi bundle
    Use 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".
    0 installs
  2. ▌
    Dax Feedback · csalcedodatabi
    Use 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.
    0 installs
  3. ▌
    Dax Reference · csalcedodatabi bundle
    Use 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", "difference between DAX functions", "is X deprecated", "context transition", "write the measures", "example PBIP".
    0 installs
  4. ▌
    Dax Lib Install · csalcedodatabi
    Use 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".
    0 installs
  5. ▌
    Dax Udf Authoring · csalcedodatabi
    Use 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".
    0 installs
  6. ▌
    Dax Window Functions · csalcedodatabi
    Use 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".
    0 installs
  7. ▌
    Svg Recolor For Power Bi · csalcedodatabi bundle
    Cambia el color de los iconos SVG de un proyecto PBIP sin tocar nada más — detecta qué colores hay, sustituye solo los que son colores de verdad (no referencias `url(#id)` ni selectores CSS), conserva la codificación de cada archivo y avisa de lo que no puede reescribir.
    7 installs
  8. ▌
    Power Bi Semantic Architect · csalcedodatabi bundle
    Transforma modelos de datos técnicos de Power BI en modelos semánticos documentados — genera descripciones, KPIs y un Context Store completo usando MCP como puente de comunicación bidireccional. El analista pasa de constructor manual a Auditor de Inteligencia.
    3 installs