Forum Discussion

akhil5656's avatar
akhil5656
Frequent Visitor
9 years ago
Solved

How to change decimal number to date format

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.
Need Help
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    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"
)