Power Bi Average function help

[Mohamed Sameer Kazi]

Hi Team,

New to Power Bi,

how can i do the average for 3 column to reflect my quarterly average

in dataset i need a column or measure doing avereage for each row

Apericiate yoour support always.

 

[Mohamed Sameer Kazi]

e.g
Column A Column B Column C Average
80% 75% 80% ?

 

[Chihiro]

Sounds like you are averaging average. Which is something you shouldn't do.

Also, I'd recommend using M - Query to unpivot columns.

 

[Mohamed Sameer Kazi]

Hi chihiro,
I would to average row and put in new column as quarterly average, finding difficult to average row in power bi

 

[Chihiro]

I'd recommend that you upload sample data set (20 or so rows of data), that represent your data. Remember to desensitize sensitive info.

Without it, I'll be guessing your data structure. DAX is highly contextual language and will change based on your data model.

You can upload either zipped pbix file, or Excel file that's representative.