Forum Discussion

MBHViz's avatar
MBHViz
Frequent Visitor
2 years ago
Solved

Unable to format year column as date

Hello All,   My year column defaults to whole number when imported. I would like to change the type to date. The recommended advice in other forums is to change the type to date, then transform t...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    let
    Source = Excel.Workbook(File.Contents("C:\Users\mbhet\OneDrive\Documents\#MichaelHetheringtonConsulting\Tech\Power BI\Microsoft Power BI Data Analyst\Data\AdventureWorksData.xlsx"), null, true),
    Date_Sheet = Source{[Item="Date",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Date_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Year", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Year1", each #date([Year],1,1),type date)
    in
    #"Added Custom"

MBHViz1's avatar
MBHViz1
Regular Visitor
2 years ago

Thanks for the prompt reply. I'm not understanding where to enter that. I'm attempting to use that code to generate a new column, then the old column could be deleted?

Using the new column selection, Year1 = #date([Year],1,1) returns an error message

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 2, #