Forum Discussion
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...
Hi,
Does this work?
=DATEDIFF(MAX(Data[VacDate]),TODAY(),Month)
If VacDate is a column, then you need to wrap it in an aggregator like MAX or MIN. If it is a measure, then [VacDate].
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490