Custom Column Power Query

[Anonymous]

Hi Experts

need a custom column to do the following if the date is current month -1 then "Actual" ie. Feb 21 and all historical months in year and any future period then return "4YOP".

[amitchandak]

@Anonymous , Try a new column like

if [Date] >= Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)) and [Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"

[Anonymous]

Getting an error here "Actual" - message Token Eof expected? - or alternatively on then

[amitchandak · Accepted solution]

@Anonymous , you have shared your formula. I copy passed same in my file and changed the date and it worked , only in bold need to be changed

if [Sales Date] >= Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)) and [Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"

[Anonymous]

Apologies my fault... i had IF as opposed to if.... thanks Amit