Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
LuisGerardoSR
Helper II
Helper II

How to get the Average of a row

Hello everyone!

 

How can I get the average for each row in this table?

i.e: What is the average for the toys in store 1?

 
CompanyToy #1Toy #2Toy #3
Store #1$1.5$2.25$3.15
Store #2$5.25$4.25$3.75
Store #3$6.25$5.5$4.25

 

2 ACCEPTED SOLUTIONS
mahoneypat
Microsoft Employee
Microsoft Employee

First thing would be to unpivot the data in the query editor, and rename the attribute column to ToyNumber.  You can then just write a simple DAX measure like

 

Avg Measure = average(TableName[Value])

 

Then just make a table visual with the ToyNumber and this measure.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

amitchandak
Super User
Super User
2 REPLIES 2
amitchandak
Super User
Super User

mahoneypat
Microsoft Employee
Microsoft Employee

First thing would be to unpivot the data in the query editor, and rename the attribute column to ToyNumber.  You can then just write a simple DAX measure like

 

Avg Measure = average(TableName[Value])

 

Then just make a table visual with the ToyNumber and this measure.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors