Free Excel Formula to DAX Converter
Paste a SUMIFS, VLOOKUP, COUNTIFS, or SUMPRODUCT formula — get back the real Power BI DAX equivalent, not a word-for-word guess.
Why this isn't a word-for-word rewrite
Excel and DAX look similar on the surface but work on completely different models. A SUMIFS becomes CALCULATE(SUM(...), ...) with each condition as its own filter argument, not a nested FILTER(). A VLOOKUP becomes RELATED() when a real relationship already connects the two tables, or LOOKUPVALUE() when it doesn't -- picking the wrong one is the single most common mistake people make translating by hand.
Array and spill formulas are the one real exception: DAX's row context doesn't work like Excel's spill behavior, so a literal rewrite usually produces the wrong answer. This tool says so plainly and gives a real DAX approach (usually SUMX) for getting the same result instead of forcing a translation that won't actually work.
A worked example
Paste: =SUMIFS(Sales!B:B, Sales!A:A, "West"). This comes back as CALCULATE(SUM(Sales[Amount]), Sales[Region] = "West") — with sensible placeholder column names since the formula only had raw cell ranges, flagged clearly in the explanation so you know exactly what to rename.
Questions
Does VLOOKUP have a direct DAX equivalent?
Not literally — DAX uses RELATED() when a real relationship already links the two tables, or LOOKUPVALUE() when it doesn't. This tool picks the right one and explains why.
What about array or spill formulas?
Those don't translate one-to-one — DAX's row context works differently from Excel's spill behavior. The tool says so plainly and gives a real DAX approach (usually SUMX) for getting the same result instead of forcing a literal rewrite.
Is this free?
Yes, completely free, no account or signup needed.
I don't have an existing formula — can it just write one from scratch?
Yes — the DAX Formula Generator describes a metric in plain English and writes a fresh measure instead of converting an existing one.
Got your measure? Build the whole dashboard.
Upload your data, describe what you want, and get back a real, editable .pbip project today — free, no Fabric or Copilot license needed.
More free tools: DAX formula generator · DAX explainer · DAX cheat sheet · see all →