Formatting DAX in the browser

DAX is easier to review when it is indented and wrapped consistently. BI Workbench formats a measure in the browser so you can paste a readable version into the model. Work stays on the machine; nothing is uploaded.

Why format before you commit

A measure written in a hurry is usually one long line. That is fine until someone else has to change a filter or a variable.

Formatting does not change the result. It changes whether a reviewer can see the CALCULATE, the variables, and the return in one pass.

What BI Workbench does

Paste the DAX, format it, and copy the result. The page also holds the date table, time-intelligence, TMDL, and theme tools, so a measure can be cleaned up in the same session as the rest of the model work.

The tool is the same one I use when a measure is coming back from a review and the first job is to make it readable.