topic Re: Datesadd function Issue in DAX Commands and Tips

Datesadd function Issue

Preeti_Yadav — Thu, 29 Jul 2021 13:14:41 GMT

Hi,

I am simply trying to implement the Datesadd function:

Datesadd = DATEADD(Billable[ToDate],-1,MONTH), but it is showing me the following error

Any help will be much appreciated!!

Thank You!!

Preeti Yadav

Re: Datesadd function Issue

Greg_Deckler — Thu, 29 Jul 2021 13:20:30 GMT

Preeti_Yadav well, you can get around that by using an aggregator like MAX around your Billable[ToDate] column reference but whether that is the ultimate fix is hard to say.

Re: Datesadd function Issue

m3tr01d — Fri, 30 Jul 2021 16:32:59 GMT

Preeti_Yadav Where are you using this dax expression?
Is it in a measure, calculated column?

Do you expect the result to be a date or a table?