How to standardize measurement units in excel before loading into power bi
- Step 1Identify columns with mixed units in your Excel export — Check the source documentation for columns that may contain mixed measurement units.
- Step 2Apply conversion rules to standardise — Enter Multiply/Divide rules per column to convert everything to a single target unit.
- Step 3Import the standardised file into Power BI — All DAX SUM and AVERAGE measures now produce correct unit-consistent results.
Frequently asked questions
Can I add a DAX calculated column for unit conversion in Power BI instead?+
Yes — but a DAX column requires knowing the source unit of each row. If rows don't have a unit flag column, pre-converting in the source is the only option.
Does the tool add a unit label column to the output?+
Not automatically. You can add a static 'Unit' column manually in Excel after conversion, or add it as a calculated column in Power BI.
Can I convert currency columns (GBP to USD) with this tool?+
Yes. Enter a multiply factor (e.g. 1.27 for GBP to USD). Note that exchange rates change — using a static factor means the conversion is a snapshot, not live.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.