Combine and get average value from rows based on unique ID

[am_i_really]

Hi All, 

I currently have a column with 3 rows each that have the same unique ID with 3 different values in the corresponding column. I'm looking to average the value in the "NPS Score" Column and have only one row per unique ID. Table name is "NPS Rating".

Thanks in advance!

[Ashish_Mathur]

Hi,

You may drag the Inspection ID to the row labels of a Table/Matrix visual and use this measure

Avg = average(Data[NPS Score])

Hope this helps.

[lbendlin · Accepted solution]

In Power Query choose "Group by". Group by [Inspection ID] and add a column that computes the average of [NPS score]