Forum Discussion
Creating custom columns keeps returning a structured Table column
If you are using the UI to add a column you do not need to write "Table.AddColumn". You would only need to write everything you have after the 'each'
Now I'm not sure i understand your question.
Could you paste all your M code here?
I've tried both this
Table.AddColumn(Access_Table, "Proper Date", each
let
DateNumber = [Date],
Year = Number.IntegerDivide(DateNumber, 10000),
Month = Number.IntegerDivide(Number.Mod(DateNumber, 10000), 100),
Day = Number.Mod(DateNumber, 100)
in
#date(Year, Month, Day)
)
and this
= Table.AddColumn(Access_Table, "Proper Date", each
Date.FromText(Text.From([Date]), [Format="yyyymmdd"])
)
And the resulting column populates Table links instead of the calculated values:
For the second calculation, I get this error when I click through the Table links to see the values:
Parameter.Error: We couldn't use the specified value as a date format because it includes a time component.
Details:
Format=yyyymmdd
What does
Table.AddColumn(#"Added Column", "Proper Date", each Date.From([Date]), type date)return?
Oh I think I know what it might be - I'm clicking the Custom Column function, which adds an extra
Table.AddColumn(Access_Table, "Custom", each Table.AddColumn(Access_Table, "Proper Date", each
let
DateNumber = [Date],
Year = Number.IntegerDivide(DateNumber, 10000),
Month = Number.IntegerDivide(Number.Mod(DateNumber, 10000), 100),
Day = Number.Mod(DateNumber, 100)
in
#date(Year, Month, Day)
))
How do I add a custom column without incurring that code addition, or what do I omit?