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.

Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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.