Apr 15 2019
10:48 PM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
Apr 15 2019
10:48 PM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
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 display their AVERAGE in power Bi ... would you please show me how? thank you in advance
May 06 2019 11:39 PM - edited May 07 2019 07:04 AM
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]))
May 07 2019 06:46 AM
May 07 2019 07:01 AM
@AKP_1 , if you use filters when with CALCULATE, otherwise why to complicate. Here is Excel data model environment, but in Power BI it's the same