Datesadd function Issue

[Preeti_Yadav]

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

[m3tr01d]

@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?

[Greg_Deckler]

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