Forum Discussion
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(
VALUES( CUSTOMER[Gender] ),
"@Read Sales",
CALCULATE(
[SALES AMOUNT],
'Product'[Color] = "Red"
)
)
-- BUT THIS
EVALUATE
ADDCOLUMNS (
VALUES ( CUSTOMER[Gender] ),
"@Read Sales",
CALCULATE (
[SALES AMOUNT],
'Product'[Color] = "Red"
)
)
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:
- 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.
- 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.
- 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.
- Paste exactly this (with spaces already there):
7 Replies
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 😉
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
yeah i tried it with off before i posted didnt make difference. i switched it again before making this post this is what i see
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:
- 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.
- 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.
- 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.
- Paste exactly this (with spaces already there):
Hi stribor45,
Thank you for posting your query in the Microsoft Fabric Community Forum.As per my understanding, the “Skip space after function name” setting primarily prevents the formatter from removing spaces if they already exist; it doesn't automatically insert them into code that lacks them. So if the original code has no space (like ADDCOLUMNS(), formatting won't add one even when the option is off but once you add it (manually or via Find/Replace), future formatting will preserve it.
For official details, check these references:
- DAX Studio Options docs: https://daxstudio.org/docs/features/options/options-window-standard (see the "Skip space after function name" row. default false means space included when unchecked).
- SQLBI's 2020 announcement explaining the change and toggle: https://www.sqlbi.com/blog/marco/2020/01/23/a-small-change-in-dax-formatter-and-in-dax-formatting-rules (covers why the rule shifted and how to enforce the spaced style).
- General DAX formatting rules: https://www.sqlbi.com/articles/rules-for-dax-code-formatting/
If adding spaces via Ctrl+H (Find: ( → Replace: () once per query works for you, that's the quickest workaround and Thanks, pcoley, OwenAuger & FBergamaschi for sharing valuable insights.
Best regards,
Ganesh Singamshetty.Thank you for sharing this documentation as i was aware of it and looked at it before posting. I was more interested why it is noted in the settings "Skip space after function name" this way and I guess I misunderstood what it does.
Thank you for your response
