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.
Hi,
I want some help with the below example.
10 | ||||
22 | ||||
27 | ||||
45 | ||||
155 | include | Avg:- 29 | ||
15 | exclude | Avg:- 21 | range | 5 to 45 |
14 | ||||
10 | ||||
22 | ||||
15 | ||||
14 | ||||
21 | ||||
23 | ||||
21 | ||||
25 | ||||
23 | ||||
26 |
in the above example, I want to define the range to calculate the avg in between 5 to 45.
whatever number range between 5 to 45 only those number average should be calculated.
Regards,
Sameer
Hi @sameergupta60 ,
I can find that 29 = AVERAGE(A5:A17). But how is "21" calculated?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
@sameergupta60 , You can create a measure or column like
averageX(filter(table, table[value]>= 5 && table[value]<= 45),table[Value])
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |