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
    • fullstop (.) for the decimal separator
  • “European”
    • semicolon (;) for list items
    • comma (,) for the decimal separator
  US European
Decimal Numbers 1.25 1,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.