USERCULTURE
The model's culture, such as nb-NO (en-US when the model names none).
Group: Information. Compatible with DAX.
Syntax
USERCULTURE ( )It takes no parameters.
Returns
Text. A language tag such as en-US or nb-NO: the model's culture.
Remarks
- The culture is a setting of the model; every query on it gets the same answer, whoever runs it.
- Its use is choosing words or a number format by language:
SWITCH ( USERCULTURE (), "nb-NO", "Salg", "Sales" ). - A model with no culture set answers en-US.
Compared with DAX
Power BI gives the culture of the person viewing the report, from their browser or operating system. OpenBI gives the model's culture: a report shows one language for everyone.
Examples
The culture of the model
EVALUATE
ROW ( "Culture", USERCULTURE () )| Culture |
|---|
| (varies) |
A title by language
The Example Brewery's culture is en-US, so the English title is chosen.
EVALUATE
ROW ( "Title", SWITCH ( USERCULTURE (), "nb-NO", "Salg", "Sales" ) )| Title |
|---|
| Sales |