Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
How can I add a new table in my Power Bi column with the following date format dd/mm/yy

1 Answer

0 votes
by (22.5k points)
edited by

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

enter image description here

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!

Related questions

0 votes
1 answer
asked Jan 13, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 15, 2021 in BI by Chris (11.1k points)

Browse Categories

...