• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Bi Average function help

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.
 

Chihiro

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

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

Chihiro

Excel Ninja
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.
 
Top