CSalcedoDataBI
- 8 skills
- 0 followers
- yesterday last updated
- ▌ Dax Lib · csalcedodatabi bundleUse 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".
- ▌ Dax Feedback · csalcedodatabiUse 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.
- ▌ Dax Reference · csalcedodatabi bundleUse 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".
- ▌ Dax Lib Install · csalcedodatabiUse 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".
- ▌ Dax Udf Authoring · csalcedodatabiUse 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".
- ▌ Dax Window Functions · csalcedodatabiUse 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".
- ▌ Svg Recolor For Power Bi · csalcedodatabi bundleCambia 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.
- ▌ Power Bi Semantic Architect · csalcedodatabi bundleTransforma 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.