Forum Discussion
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:
Super UserHi Soupy127 ,
Have you tried keeping the Forms value has you have but pickup the lastnonblankvalue for each of the questions? That would give you the correponding value based on the latest form for all the questions.
Hi MFelix,
In that case, on the form would you remove the default value for each of the questions (so they are blank) and then do as you say above and it would only show the 'Yes' answers?
If so could you show me an example of were to put the 'lastnoblankvalue' as have never used it before 🙂
Thanks again
- MFelix
No need to have the blanks,
I will setup an example and send it tomorrow
Brill Miguel, thanks very much for your help!
- MFelix
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