Forum Discussion
Date Functions and reference
= 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.
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.
1 Reply
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.