PowerBiDevCamp/TranslationsBuilder

Make possible to use partial Culture Codes

Opened this issue · 0 comments

Hi!

We currently have the automatically created measures in the likes:

Example Measure =
SWITCH(USERCULTURE(),
"en-US", "English Title",
"en-GB", "English Title",
"pt-BR", "Portuguese Title",
"pt-PT", "Portuguese Title",
"Fallback Title"
)

It would be useful to have the option to make the language generic, working independently of the country. The DAX generated would be:
Example Measure Generic=
SWITCH(
LEFT( USERCULTURE() , 2 ),
"en", "English Title",
"pt", "Portuguese Title",
"Fallback Title"
)

Thanks for the amazing work you all do,
Guilherme