Forum Discussion
gtamir
6 years agoPost Patron
Change language in Visuals
I want the month name to be in English. File > Options > Regional setting miss English UK. By the way, it misses Hebrew too. Where else can I change the language? Giora
- 6 years ago
Here your M Code:
let Source = List.Dates(StartDate, Length, #duration(1, 0, 0, 0)), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}), StartDate = #date(2018, 1, 1), Today = DateTime.Date(DateTime.LocalNow()), Length = Duration.Days(Today - StartDate), Custom1 = #"Changed Type", #"Inserted Year" = Table.AddColumn(Custom1, "Fin Year", each Date.Year([Date]), Int64.Type), #"Inserted Month Name" = Table.AddColumn(#"Inserted Year", "Month Name", each Date.MonthName([Date], "en-US"), type text), #"Inserted Day Name" = Table.AddColumn(#"Inserted Month Name", "Day Name", each Date.DayOfWeekName([Date], "en-US"), type text), #"Inserted Month" = Table.AddColumn(#"Inserted Day Name", "Fin Month", each Date.Month([Date]) , Int64.Type), #"Inserted Day of Week" = Table.AddColumn(#"Inserted Month", "Day of Week", each Date.DayOfWeek([Date])+1, Int64.Type), #"Inserted First Characters" = Table.AddColumn(#"Inserted Day of Week", "MMM", each Text.Start([Month Name], 3), type text), #"Inserted First Characters1" = Table.AddColumn(#"Inserted First Characters", "DDD", each Text.Start([Day Name], 3), type text), #"Reordered Columns" = Table.ReorderColumns(#"Inserted First Characters1",{"Date", "Fin Year", "Month Name", "MMM", "Fin Month", "Day Name", "DDD", "Day of Week"}), #"Added Custom" = Table.AddColumn(#"Reordered Columns", "YYMM", each ([Fin Year]-2000)*100 + [Fin Month]), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"YYMM", Int64.Type}}), #"Added Custom1" = Table.AddColumn(#"Changed Type1", "MonthID", each (Date.Year([Date]) - Date.Year(StartDate))*12 + Date.Month([Date])), #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom1",{{"MonthID", Int64.Type}}), #"Renamed Columns1" = Table.RenameColumns(#"Changed Type2",{{"Fin Year", "Year"}}) in #"Renamed Columns1"
mwegener
6 years agoMost Valuable Professional
Check this
File > Options > Current File > Regional Settings
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
gtamir
6 years agoPost Patron
Well I mentioned in my post that the two languages are not in the list. How to add languages?