Forum Discussion

Preeti_Yadav's avatar
Preeti_Yadav
Resolver I
5 years ago

Datesadd function Issue

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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.

  • m3tr01d's avatar
    m3tr01d
    Continued Contributor
    5 years ago

    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?