Forum Discussion

am_i_really's avatar
am_i_really
Frequent Visitor
1 year ago
Solved

Combine and get average value from rows based on unique ID

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!

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

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

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    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.