Forum Discussion

Frequent Visitor

10 years ago

Solved

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 spell...

Tutorial Requests

Anonymous
10 years ago
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.

Anonymous

Not applicable

10 years ago

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.