How to change decimal data type to date format in power BI

[akhil5656]

I am new to Power BI, in my data base the date column is in the format:20160301, when I was trying to insert this date column in the power BI  table it is taking as integer and giving the total.In below Images clearly shown.

MY Question is how to change 20160301 format to 03/01/2016 format in the Power BI.

Can any one explain to me how to change the format?

Thanks

[kaushikd · Accepted solution]

@akhil5656

Here is a work around

I have created a new column and used the Date function.

I have taken the orderdate from adventure work

Now Follow the steps:-

Step 1. R.Click on the table<FactInternetSales> and select New Column.

Step 2. Paste the code--->Date = Date(LEFT(FactInternetSales[OrderDateKey],4),Right(LEFT(FactInternetSales[OrderDateKey],6),2),Right(FactInternetSales[OrderDateKey],2))

Here i have done some workaround as Date function intakes 3 parameter Date(<Year>,<Month>,<Day>), so i have extracted it using LEFT() and Right() Functions.

Now you can see the new column you created is in date type.

Please dont forget to mark this as a solution if this is what you wanted.

[MarcelBeug]

Alternatively, in Power Query, you can import the data as text and then change it to date (in a separate step), e.g.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Date", type date}})
in
    #"Changed Type1"