Forum Discussion
Grouping of Dates Power Query - MS Forms results
Good evening,
I have a question where I can not find a solution for days and I hope someone can help me.
I have results from a MSForms survey, which I evaluate with Power Query. The survey is a course evaluations.
In column B are the date and time when it was filled out. In column C are the names of the courses.
My plan was to use column B to create a separate column to separate the date to better show the date of the course (which works).
For example: I have a tennis course. 17 people give an evaluation on the day of the course. So I know that the course took place on this day.
Problem: If someone gives the course one day later, I can't assign it correctly (and it looks strange in evaluations).
My question: How can I group the one result to the other results? Is there a way to assign single results to majority results?
Thanks in advance
Wolfgang
1 Reply
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
