Forms - PowerBI Help - Combine multiple rows based on 1 field and merge results

Hi Soupy127 ,

Please see the file attach. What I have done:

• Unpivot the questions and answers

• I assume that you have the date of the form also
• Add the following measure:

Last values = 
var temptable = TOPN(1, 'Table', 'Table'[Date], DESC)
Return
MAXX(temptable, 'Table'[Answer])

Final result:

The bottom table is the one with the full questions and dates the top one is the one with only the last results.

Please let me know if you need further assistance

OK,

Sorry I missunderstood tough you wanted the last response.

Just try this measure since in Yes is always after No (Alphabetically)

Last values = 
MAX('Table'[Answer])

And if you want some additional information on top of this you can have this additiona formula: