Change column type to Date in Power Bi

Question

How can I add a new table in my Power Bi column with the following date format dd/mm/yy

Answer 1

Select settings>options on the File tab When you did select the refresh option

If setting didnt work then follow this

1. Choose the data column and select Split column 
2. Merge all the columns and change datatype to Date

#"Split Column by Delimiter" = Table.SplitColumn(Table.TransformColumnTypes(#"Previous step", {{"Date", type text}}, "en-US"), "Date", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), {"Date.1", "Date.2", "Date.3"}),
#"Merged Columns2" = Table.CombineColumns(#"Split Column by Delimiter",{"Date.2", "Date.1", "Date.3"},Combiner.CombineTextByDelimiter("/", QuoteStyle.None),"Merged"),
#"Changed Type5" = Table.TransformColumnTypes(#"Merged Columns2",{{"Merged", type date}})

If you want to know more about PowerBi, check out the Power Bi Developer blog  

Intellipaat also provides Power BI Online Course, Enroll now!