Forum Discussion

steambucky's avatar
steambucky
Helper III
8 years ago
Solved

DATEDIFF syntax error in measure.

Hello I am doing some wrong here....     All i am trying to do create a measure that calculates the months since animals have been vacinated.   This is the what i am writing:   Since vac...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Does this work?

     

    =DATEDIFF(MAX(Data[VacDate]),TODAY(),Month)

steambucky's avatar
steambucky
Helper III
8 years ago

Hello Ashish,

 

Your suggestion DID work with some small modifications. Thank you for your time.

 

I am curious about the following -  This is what finally worked.

 

(My new Measure)  Since last Vac = DATEDIFF(MAX(Sheet1[VacDate]),TODAY(),Month)

 

This also worked in a new column:

 

(New Column) Since last Vac = DATEDIFF([VacDate],NOW(),Month)

 

But the same but if swap that code between the column and measure is doesnt work. Any idea why?  

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

You are welcome.  In a calculated column formula, [VacDate] picks up the value in the current row of that column column.  In a measure, when you mention [VacDate], it refer to all entries in that column.  To get it to refer to the current row, we use the MAX function.