Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
5 months ago
Solved

DAX Studio space after function name

Why cant i get this working? I am trying to have a space after the function name but no luck in DAX Studio even  though setting is there (see attached)   -- NOT THIS EVALUATE ADDCOLUMNS( ...
  • pcoley's avatar
    pcoley
    5 months ago

    If you already have it unchecked and reformatting (via the toolbar lightning bolt icon, Ctrl+K Ctrl+D, or right-click → Format DAX) still produces no space after the function names, here are the most common reasons this happens and how to fix it:

    1. The change wasn't applied / needs a restart After toggling the checkbox → click OK or Apply → close and reopen DAX Studio completely. Then paste your code fresh and format it again. Some users report the setting doesn't take effect until a full restart.
    2. You're using an outdated version of DAX Studio The option was added around early 2020 (following SQLBI's formatting rule update). If you're on a very old build (pre-3.x), it might not exist or behave inconsistently. → Go to Help → Check for Updates (or download the latest from https://daxstudio.org). As of 2026, grab the current release — it definitely supports this reliably.
    3. The code already has no spaces, or formatting is set to "Best Practice" style Some versions / integrations default to the modern SQLBI "no space after function" rule. Try this test:
      • Paste exactly this (with spaces already there):
         
         
        EVALUATE
ADDCOLUMNS ( VALUES ( 'Customer'[Gender] ), "Test", CALCULATE ( [Sales Amount] ) )
         
         
      • Format it. If it removes the spaces → the setting is being ignored or overridden. If it keeps them → good, the option is working; your original code might just need manual spaces added first before formatting.
OwenAuger's avatar
OwenAuger
Super User
5 months ago

Hi stribor45 

I believe that "Skip space after function name" should be turned off if you want a space between function name and the opening parenthesis. At least it appears to work that way when I tested it just now.

 

"Skip space" here means "do not include space", rather than "skip one character space to the right after function name".

 

Perhaps the option could be renamed 😉

FBergamaschi's avatar
FBergamaschi
Super User
5 months ago

I confrim what OwenAuger  wrote

 

I also tested your code in DAXformatter.com, there there is no need of any special setting and it works, of course it is more time consuming but just to mention that

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI