Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help convert text to data and convent number to data

hi,   i'm new here and this is my first post.   i imported from excel a db, but the format is not correct, and try to change a format but without success.   i have 2 problems with 2 different c...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"GIORNO", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.From(Text.From([GIORNO], "en-US")))
in
    #"Added Custom"

Hope this helps.