Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

Average 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...
Need Help
Show and Tell
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Your 40 result looks correct to me in both PBI and Excel.  What formula are you using in Excel?

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

mahoneypat ,

 

That's wired. I use the following approach.

First I create new column using following formula.

=DATEDIF(A2,TODAY(),"Y")

Then I calculate the average using Average() function to calculate the average value of new column.