Forum Discussion
Dunner2020
Post Prodigy
Post ProdigyAverage difference date value is different in power BI
Hi there, My sample data is present in this link: https://1drv.ms/x/s!AucycxZHFe9TjTF2d36VklLNs7UN?e=gOenxH . I am trying to calculate the average difference between the installationdate column p...
Ashish_Mathur
Super User
Super UserHi,
In cell D2, enter this formula and copy down
=DATEDIF(A2,TODAY(),"y")
Now if you average this column, the result is 40. So your DAX formulas is returning the correct result.
Hope this helps.