From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Local dates with FORMAT and USERCULTURE

Local dates with FORMAT and USERCULTURE - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Local dates with FORMAT and USERCULTURE

“

- [Instructor] We can reference the ISO-8601 format to standardize the date by the four digit year, the two digit month, and the two digit day, all separated by dashes. But what if we want to display the date within Power BI as a text label in a local language? We can use tax functions like format and userculture to convert dates into local date labels depending on the language that we want to use. The format function takes the date value input, the date format we want to display it in, and optionally, we can also include a language code to make it dialect specific. The Format Docs documentation is a great resource for seeing these available date formats. We can also use the function user culture to display the date in a Power BI environment selected language. Now let's try it out ourselves, starting with Power BI desktop. In the calculations measure group, there's already a measure for today's date using the today function. Your result for this measure will look different than mine…

Contents