How to get the Average of a row

[Anonymous]

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

[mahoneypat · Accepted solution]

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

[amitchandak · Accepted solution]

@Anonymous , unpivot this table then use it

https://radacad.com/pivot-and-unpivot-with-power-bi

[mahoneypat · Accepted solution]

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