Datediff result is Zero

[Anonymous]

I have created a Query which should bring for “date2” which has a date the following difference date1-date2 in days.

Unfortunately I have a lot of 0.

The datediff as below:

Days = 1*(if(Query[date2].[Date]<>BLANK();DATEDIFF(Query[date1].[Date];Query[date2].[Date];DAY)))

Unfortunately I got as result a lot of “0” which is used for the calculation of an average.

How can the “0”, be suppressed in order not to use it for calculation.

[jthomson]

Add an if statement to do so, either in the datediff calculation you're doing right now or in the end average you're trying to calculate, to convert your zeroes to nulls/blanks and/or filter them out?

[Anonymous · Accepted solution]

Thanks I am using the filter.