Forum Discussion
dateadd function today minus period
Table.Addcolumn needs a table parameter where you want to add the column. In my case the table is called '"Changed Type" which is the name of my last transformation step before Table.AddColumn.
Your approach was just by using the button "custom column" So there you just write
if [EndDate]<Date.AddMonths(Date.From(DateTime.LocalNow()),-3) then 1 else 0)
The rest will be added by Query Editor itself.
So when you click on the word error he will show you some details about it.
However
You say that your date column is in datetime format? Could you please write Date.From([lastLD]) instead of [lastLD]
Brackets are ok as far as i see
Thank you.
Just one small question, what does the #"Changed Type" mean?
Since it's throwing me an error.
Quick Google search didn't give me an answer right away.
edit:
seems that's the table name on which you want to add the column.
Table.Addcolumn needs a table parameter where you want to add the column. In my case the table is called '"Changed Type" which is the name of my last transformation step before Table.AddColumn.
Your approach was just by using the button "custom column" So there you just write
if [EndDate]<Date.AddMonths(Date.From(DateTime.LocalNow()),-3) then 1 else 0)
The rest will be added by Query Editor itself.
still not working
I've altered it to:
= if [lastLD]>Date.AddMonths(Date.From(DateTime.LocalNow()),-3) then 1 else 0
The column gets created but only contains Error.
If I add an ) on the end, I get a Token Eof expected error, which seems valid to me, since that one doesn't belong to anything.
de lastLD is formatted in d-m-yyyy h:mm:ss