Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
Thanks I am using the filter.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
100 | |
87 | |
72 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |