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:
- comma (,) for list items
- period (.) for the decimal separator
- semicolon (;) for list items
- comma (,) for the decimal separator
|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.