Forum Discussion

thegusman's avatar
thegusman
Helper I
5 years ago
Solved

Creating a custom column and changing the data type within the custom column formula

Hi All,    I'm trying to learn how I can create a custom column, let's use       =Date.EndOfMonth(Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1)) and within the same custom column formula ...
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Does this work?

    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.EndOfMonth(Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1)), type date)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Does this work?

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.EndOfMonth(Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1)), type date)
thegusman's avatar
thegusman
Helper I
5 years ago

Yes it does. Thank you!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    You are welcome.