cancel
Showing results 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

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?

 Company Toy #1 Toy #2 Toy #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
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!

Super User
2 REPLIES 2
Super User
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!