Skip to main content

Swap Delimiters

Note: In the Options there is a setting to select a default delimiter style

In Excel and Power BI DAX supports 2 styles of delimiters:

  • US
    • comma (,) for list items
    • period (.) for the decimal separator
  • "European"
    • semicolon (;) for list items
    • comma (,) for the decimal separator
Decimal Numbers1.251,25
List of Strings"Red","Green""Red";"Green"

The "Swap Delimiters feature lets you easily take DAX queries or expressions and switch between the two delimiter styles. This is very handy when copying examples from websites where they have used the alternate delimiter style.