Forum Discussion
ahmad ali
Apr 16, 2019Brass Contributor
Power bi and Average
Hello, I've been using Pivot-tables where we can easily choose Average,sum,... (like the image below) - but is there something like that in Power bi - I have values but I don't know how the find or...
AKP_1
May 07, 2019Copper Contributor
You will need to use DAX to calculate the average of the entity. For example if the table is called flour and you have sales column,
To calculate the sum,
Sum = (Sum(flour[sales]))
While the average will be
Average = (Average(flour[sales]))