Solved: Date Functions and reference

singhswat · ‎07-07-2016

= DateAdd(DateTime.Date(DateTime.LocalNow()), 6, MONTH)
OR
= DATEADD(DateTime.Date(DateTime.LocalNow()), 6, MONTH)

Expression error: The name 'DateAdd' wasn't recognized. Make sure it's spelled correctly.

Also, Can someone pls share a functions reference link so that I can bounce myself over it before I post basic questions

Thanks for the replies.

Anonymous · ‎07-07-2016

@singhswat DATEADD is a DAX language function and DateTime.Date and DateTime.LocalNow are M language functions. You are apparently in the query editor, which does not use DAX. The M equivalent of DATEADD is Date.AddDays but in your case it may be better to use Date.AddMonths.

View solution in original post

Anonymous · ‎07-07-2016

@singhswat DATEADD is a DAX language function and DateTime.Date and DateTime.LocalNow are M language functions. You are apparently in the query editor, which does not use DAX. The M equivalent of DATEADD is Date.AddDays but in your case it may be better to use Date.AddMonths.