How to change decimal number to date format

[akhil5656]

In my table date format is in decimal format as shown: 20160327

How can change into the correct format as 03/27/2017 in Power Bi Desktop?

Can any one help me?

Thanks.

[v-chuncz-msft · Accepted solution]

@akhil5656,

You may add a custom column in Query Editor.

Date.ToText(
#date(
Value.FromText(Text.Start(Text.From([Column1]),4))
, Value.FromText(Text.Range(Text.From([Column1]),4,2))
, Value.FromText(Text.End(Text.From([Column1]),2))
)
, "MM/dd/yyyy"
)

[MarcelBeug]

Again??? https://community.powerbi.com/t5/Desktop/How-to-change-decimal-data-type-to-date-format-in-power-BI/...