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 All,
If i have set of values ( 1, 2 , 2 ,4 ) i want to make a measure to take an average without decimal ( i mean the value to be 2 not 2.25 and so on )
Solved! Go to Solution.
Try this one:
_Convert = ROUND(AVERAGE('Table'[Column1]), 0)
https://docs.microsoft.com/en-us/dax/round-function-dax
Try this measure:
_Avg = INT(AVERAGE('Table'[Column1]))
https://docs.microsoft.com/en-us/dax/int-function-dax
@camargos88 thanks it works fine but it converts 3.75 to 3 i want it to convert it to 4 ( the nearst value above or below )
Try this one:
_Convert = ROUND(AVERAGE('Table'[Column1]), 0)
https://docs.microsoft.com/en-us/dax/round-function-dax
Can you send me the values ?
@camargos88 this measure will work on a large set of data the values in the data are ( 1,2,3,4 ) the this values will be repeated every day at least 100
And I want the average to be the nearest value
If it 3.7 to be 4
If it 3.2 to be 3
I don't think it depends on the number os values, on it's the average.
See the documentation about this function:
@camargos88 that's what I'm trying to say that the set of values I use right now will not affect the average
Do you think there is an error in the formula or I use it wrong ?
Try with these values:
1,2,2,4,8,5.5
It should return an average of 3.75...with the measure should be 4.
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |