Power BI Tools
Generators for the parts of a Power BI model you end up writing over and over. Pick your options, check the preview, and paste the result into your model.
DAX Formula Builder
Describe a calculation in plain English and get a working DAX measure or Power Query M step, with an explanation of every function it uses.
OpenDate Table Generator
A complete date table in DAX or Power Query M, with fiscal years, ISO weeks, day-of-week, and relative-date columns, plus a row preview.
OpenTime Intelligence Generator
YTD, prior year, YoY %, rolling 12 months, and running totals for any measure, as separate measures or one calculation group.
OpenFormat String Builder
Custom format strings for K, M, and B, currency, percentages, and negatives in parentheses, checked against real values before you paste.
OpenField Parameter Generator
Let users pick which measure or column a visual shows: display names, sort order, and grouped options, with a slicer preview and a dynamic title.
OpenEVM Calculator
BAC, PV, EV, and AC in; CPI, SPI, EAC, ETC, VAC, and TCPI out, with a plain-English status, three EAC methods compared, and the DAX.
OpenReliability Calculator
Paste a failure log or enter totals for MTBF, MTTR, availability, failure rate, and mission reliability, per asset, with the DAX.
OpenRisk Matrix Builder
Paste a risk register for a 5×5 heat map, scores, adjustable Critical/High/Medium bands, a ranked list, and the DAX with matrix cell colors.
OpenFMEA Calculator
Paste failure modes for RPNs and High/Medium/Low action priority, with a severity override that catches rare but serious failures, and the DAX.
OpenLooking to see how a function behaves rather than generate one? The interactive examples let you change the inputs to DAX and Power Query functions and watch the results update.